| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, how do I set a formula to skip a cell if zero?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, how do I set a formula to skip a cell if zero?
If you use AVERAGE(), it skips empty cells automatically.
In article , hlpme wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, how do I set a formula to skip a cell if zero?
OK, so what if the total sum needs to be divided by the number of entries?
Thanks-- VERY much "JE McGimpsey" wrote: If you use AVERAGE(), it skips empty cells automatically. In article , hlpme wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, how do I set a formula to skip a cell if zero?
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) In article , hlpme wrote: OK, so what if the total sum needs to be divided by the number of entries? Thanks-- VERY much "JE McGimpsey" wrote: If you use AVERAGE(), it skips empty cells automatically. In article , hlpme wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i get a IF formula to skip to the next reference box | Excel Worksheet Functions | |||
| I want to copy a formula n Excel but skip any blank cells | Excel Worksheet Functions | |||
| formula in excel to skip cells having - number and add only + | Excel Worksheet Functions | |||
| formula(excel) to skip cells having - number and add + one | Excel Worksheet Functions | |||
| Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
Linear Mode
