Thread: Running average without nonzero values or empty cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wjsubs[_3_] wjsubs[_3_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote