Tabulating entries with a formula

[trumpet717]

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".

[#2]

@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

[#3]

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?

@RonR 

[#4]

Sorry, make that column E.

@RonR