View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Renee Renee is offline
external usenet poster
 
Posts: 73
Default If statement then Average

I have a column that has percentages in it; some have #'s great than zero
while others show a zero percentage. I would like my formula to say if the
cell = 0% then don't include in average calculation. Is this possible?

Thank you,
Renee