Use SUMIF/COUNTIF
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Help" wrote in message
...
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