Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to avoid excel adding a 0 for cells with a formula
I have a running average that counts 0 as a value.
My data set contains a simple addition function that I have autofille to empty entries in order to make data entry in the future easier. (th addition will automatically be computed for new data points) My COUNTIF & SUMIF functions both count 0 as a value for the runnin average. I was wondering if anyone knows how to avoid having exce automatically enter a zero into the sum cell when there arent an values entered for that particular data point. I am looking for a wa to keep the formula while avoiding the skewing of my data. Thanks, Wil -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to avoid excel adding a 0 for cells with a formula
Change simple addition function to:
=IF(simple addition function=0,"",simple addition function) wjsubs < wrote: I have a running average that counts 0 as a value. My data set contains a simple addition function that I have autofilled to empty entries in order to make data entry in the future easier. (the addition will automatically be computed for new data points) My COUNTIF & SUMIF functions both count 0 as a value for the running average. I was wondering if anyone knows how to avoid having excel automatically enter a zero into the sum cell when there arent any values entered for that particular data point. I am looking for a way to keep the formula while avoiding the skewing of my data. Thanks, Will --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF - how to avoid cells with no value | Excel Discussion (Misc queries) | |||
can i avoid repeating rows when adding calculated item in pivot ta | Excel Worksheet Functions | |||
Excel truncated my cells when copying, how to avoid?? | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Need formula to avoid ":" in cells with tt:mm | Excel Worksheet Functions |