Running average without nonzero values or empty cells
 

I have a column that I want to have a running average going in.

My current formula seems to be including either cells with a value o
0, or empty cells where I am waiting to add data to.

If anyone can help that would be great.

Here is my formula:

=SUMIF(B$14:B$109,"<0")/COUNTIF(B$14:B$109,"<0")


Thanks,

Wil

--
Message posted from http://www.ExcelForum.com

Running average without nonzero values or empty cells
 

if you don't have negative numbers:

=SUMIF(B$14:B$109,"0")/COUNTIF(B$14:B$109,"0")

--
Regards,
Tom Ogilvy

"wjsubs " wrote in message
...
I have a column that I want to have a running average going in.

My current formula seems to be including either cells with a value of
0, or empty cells where I am waiting to add data to.

If anyone can help that would be great.

Here is my formula:

=SUMIF(B$14:B$109,"<0")/COUNTIF(B$14:B$109,"<0")


Thanks,

Will


---
Message posted from http://www.ExcelForum.com/