If your formulas looked like: =sum(a2:A99)
then maybe using =subtotal(9,a2:a99)
would work better.

=subtotal() can ignore cells that are hidden by an autofilter.



fourskunks wrote:

Help!

I have a field called date entered and lots of formulas. My problem is that
when I applied the filter non of my formulas change. I am trying to keep a
count going for every month itself and YTD stuff.

Is there a way to do this right? I am going to deal with 31 different
spreadsheets where they are being compared to one another.

Oh boy big project!

fourskunks

--

Dave Peterson