View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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