Running average without nonzero values or empty cells

  • Thread starter Thread starter wjsubs
  • Start date Start date
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
 
if you don't have negative numbers:

=SUMIF(B$14:B$109,">0")/COUNTIF(B$14:B$109,">0")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A data validation question 1
Run select query from VBA code where criteria comes from a multi select ListBox 2
Excel Sumproduct 0
Excel formula, sum the value cell and if empty cell left blank 0
Excel Need Countifs Formula Help 0
Modify working code to expand the output. 5
Trying to run excel vba code when cell value changes from empty to entered value. 1
Sumif similar to Countif?? 3

Back
Top