View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Wigi Wigi is offline
external usenet poster
 
Posts: 396
Default Is it possible to not count hidden cells?

Hi

Have a look at the SUBTOTAL function.

In particular, pay attention to which argument you should use.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Jimbob" wrote:

I am trying to set up a log, of sorts that will allow me to keep running
totals. I need this to take the numbers out as the rows are hidden (upon
completion of the task). Is this a possiblity through any normal excel
functions, or is this something that will require a macro? I am running
excel 2003.

Thanks,