Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace nonzero values with 1 | Excel Worksheet Functions | |||
how do I average a range which also contains empty cells | Excel Discussion (Misc queries) | |||
skip cells with zero values in chart (cells not empty) | Charts and Charting in Excel | |||
average formula ingoring empty cells | Excel Worksheet Functions | |||
How to skip empty cells while running a macro? | Excel Programming |