View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shay-rot Shay-rot is offline
external usenet poster
 
Posts: 1
Default How do I keep count in an Excel spreadsheet?

I have created spreadsheet to keep a detailed track of days travelled. It is
basically functional (and very pretty) but I need more from it. Some cell's
(representing days) throughout a given month have either a 1 or 1/2. I am
looking for a formula that can keep a count every time I put a 1 or 1/2 in
these cells - ..but for an entire month...without the =sum formula because it
takes too long. And then I would like a simple formula for the year to date
tracking. I know there is a count in Excel but cannot figure out how to use
it. This may be simple but I just can't get it...please help!

Thanks