Aug 01 2020 03:02 PM
I am looking to track entries into cells. I will actually be posting currency numbers in each cell, but also want to be able to track how many cells have entries.
An example attached: The answer in "days srv" should be "5".
Aug 01 2020 05:52 PM
@trumpet717 The quick answer is to use the COUNT function.
Put this in "days srv" column: =COUNT(C2:G2) Replicate down the column.
This will give a count of numbers but will ignore text, etc. As long as you're just entering currencies (numbers), the COUNT function should be fine. If you need more complex counting, have a look at the COUNTA or COUNTIF functions. Excel HELP explains how each function works.
Post back if you still need help. ~RonR
Aug 01 2020 06:09 PM
Ron- quite helpful to begin with!
Now I'm attaching a larger version. Please note the spreadsheet hides certain columns, as I use those cells for another tracking (weekly avg.). How would I include all the visible cells into the total in column B?