In Excel, how do I set a formula to skip a cell if zero?

  • Thread starter Thread starter hlpme
  • Start date Start date
H

hlpme

I am looking to create a formula for that will skip the cell if nothing is
entered in it. I have an chart of inventory for the month, but each day I
enter the inventory and it calculates the average. How can I have the formula
calculate for the days entered with disregard for the empty cells?
 
OK, so what if the total sum needs to be divided by the number of entries?
Thanks-- VERY much
 
Well, since that's exactly what AVERAGE() does, that's what I'd use...

But since SUM() and COUNT() also ignore blanks you *could* use

=SUM(rng)/COUNT(rng)
 

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 Vlookup Help 0
Can I get a cell to automatically rezero after entering a value. H 1
Trailing 30 days sum calculation with excel 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel formula, sum the value cell and if empty cell left blank 0
Excel IF Formula for an inventory... 7
Excel 2003 - Skip a cell 5
Help with a formula 1

Back
Top