update subtotals based on filters

[Ned Fraser]

How can I create a subtotal that is updated based upon my filter?
It seems as if the subtotal calculates all values of the column, instead of
the values showing when I apply my filter.

thanks in advance,
Ned.

 

[Guest]

it sounds as though you are using the wrong funtion number in subtotal
1-11 include hidden numbers, 101-111 exclude hidden numbers

 

[Ned Fraser]

Is there anything like this for "countif"?
-Ned.

it sounds as though you are using the wrong funtion number in subtotal
1-11 include hidden numbers, 101-111 exclude hidden numbers

 

[Guest]

No,
however depending on what you want sumproduct may give you what you want