average fomula using also count if

[gewilson]

I have columns in a spreadsheet - one is animal type the next is animal age. I need to find the average age of dogs. I was thinking =countif(animaltype,("Dog"))) but also need to find the average of that total.

 

[fred]

u can use averageif function


= averageif(column1,criteria"dog",column2)

 

[gewilson]

Thanks Fred! I was using column headers in the example below (category & rating). I want it to average all the numbers in the rating column if the category is accessibility. Sorry for the lame example.


=AVERAGE(COUNTIFcategory,"Accessibility")+COUNTIFrating,">0")