Thread: Averageif Calcs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
help help is offline
external usenet poster
 
Posts: 67
Default Averageif Calcs

I'm using windows XP (older version) which does not recognize the averageif
formula. I need a formula that calcs the average of four different data
points some of which contain zeros. Example:

A B C D avg
1 5 0 10 15 10