How to avoid excel adding a 0 for cells with a formula

  • Thread starter Thread starter wjsubs
  • Start date Start date
W

wjsubs

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
 
Change simple addition function to:
=IF(simple addition function=0,"",simple addition function)
 

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

Excel Need Countifs Formula Help 0
Avoid error with simple subtraction function 1
How to avoid arrey formula? 5
hide multiple worksheets based on a formula value in one cell 1
Counting calculated formulas in a Column 3
Data Validation blanks for formulas 18
How to Differentiate between a Student's Score of "0" and a Score of Null? 6
Can you calculate the Median without each value in separate cells? 5

Back
Top