How do I keep count in an Excel spreadsheet? Shay-rot 21.09.2006 14:47:02 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

RE: How do I keep count in an Excel spreadsheet? sjk153 21.09.2006 15:13:02 To count numbers use the formula [ at ]count(RANGE); If you have text or labels try [ at ]counta(RANGE); If you want to count a specific item like the text Scott then use [ at ]countif(RANGE,"Scott") or [ at ]count(RANGE, criteria) "Shay-rot" wrote: [Quoted Text] > 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 >