Thread
:
Averageif Calcs
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Averageif Calcs
Or sumproduct/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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett