Multiple sear criteria

Dear experts, in a work sheet i want four or five searching key cells with
subtotal.
suppose, i want to search with "StartDate and enddate" "Region", "Items",
"Name",and so on. remember that one or all of the searching keys will give
the result with subtotal.

thanking you in advance

Shah Alam

Shah Alam,

Select the cells in your datatable on your worksheet, and use Data / Filter... Autofilter

Then from each dropdown, select the item as needed (date ranges, etc).

All SUBTOTAL formulas will update to give the required value based on the filtering.

HTH,
Bernie
MS Excel MVP


"Shah Alam" wrote in message
...
Dear experts, in a work sheet i want four or five searching key cells with
subtotal.
suppose, i want to search with "StartDate and enddate" "Region", "Items",
"Name",and so on. remember that one or all of the searching keys will give
the result with subtotal.

thanking you in advance

Shah Alam

Thank you BD. but i want it typing the search items.

Best luck

Shah alam


"Bernie Deitrick" wrote:

Shah Alam,

Select the cells in your datatable on your worksheet, and use Data / Filter... Autofilter

Then from each dropdown, select the item as needed (date ranges, etc).

All SUBTOTAL formulas will update to give the required value based on the filtering.

HTH,
Bernie
MS Excel MVP


"Shah Alam" wrote in message
...
Dear experts, in a work sheet i want four or five searching key cells with
subtotal.
suppose, i want to search with "StartDate and enddate" "Region", "Items",
"Name",and so on. remember that one or all of the searching keys will give
the result with subtotal.

thanking you in advance

Shah Alam