View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hlpme hlpme is offline
external usenet poster
 
Posts: 4
Default 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?