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?
|