Sum Function that does not include 0
Well, you were expecting a value of 4, that is why I did it that way, since
you have a total of 22 calls over 6 days (the 4th having 0 calls), would
actually be less than 4. That being said, why do days that have yet to occur
have any value in them?
--
John C
"Txlonghorn76" wrote:
What if the call number is actually a "0" for the day?
"John C" wrote:
=SUM(B2:K2)/COUNTIF(B2:K2,"0")
Hope this helps.
--
John C
"Txlonghorn76" wrote:
I have a spreadsheet that has dates on the rows and daily counts for
coworkers in the columns. These numbers are pulled by Hlookup formulas in the
cells that pull from another worksheet. I want to have a running
month-to-date average without including the days that haven't it average the
days that haven't occurred. The current formula I'm using =SUM(B2:K2) gives
me and output of 2 but I'm looking for an output of 4.
01-Oct 02-Oct 03-Oct 04-Oct 05-Oct 06-Oct 07-Oct 08-Oct 09-Oct
10-Oct
Calls 1 7 6 0 3 5 0 0 0 0
|