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

Hi Tom

See the help for the Subtotal worksheet function


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tom Westlake" <tomwest@primus.ca> wrote in message news:rae174p5pe7fjsk3ucut1r4dd71mhf0t7f@4ax.com...
> 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