=SUMPRODUCT(--(A1:A15="Cat"),--(B1:B15))/COUNTIF(A1:A15,"Cat")
Swap Dog for Cat,
Regards,
Alan.
"MadameJunk" wrote in message
...
Example:Excel worksheet-Column A has list of Cat or Dog (say 15
items)-Column
C has their age in days old (10,3,4,etc)
I need (2) Averages- Average age of Cats and Average Age of Dogs