Counting & Filters

[Tom Westlake]

Hi All,

Hoping somebody can help me here. I have forgotten how to create a
formula which will tell me how many rows are visible after setting a
filter. I would like to know the results to calculate the number of
call types made in a day by changing the filter and returning a
result.

Tom Westlake

 

[Ron de Bruin]

Hi Tom

See the help for the Subtotal worksheet function