Running average without nonzero values or empty cells

W

wjsubs

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
 
T

Tom Ogilvy

if you don't have negative numbers:

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