Hi!
=SUMIF(A1:A50,"cat",C1:C50)/COUNTIF(A1:A50,"cat")
Do the same for dog.
Biff
"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
|