=Averageif help

**pmdcmatt** · 04-23-2013, 04:21 PM

First, thank you for the great help I always get on here.

I would like to average the values in row 7 if the value in row 8 is dog or horse.

I was trying =AVERAGEIF(A8:C8,"dog,cat",A7:C7)

Is there a way to do this?

Thanks again

sample.xls

**Jonmo1** · 04-23-2013, 04:25 PM

Try

=SUM(SUMIF(A8:C8,{"dog","horse"},A7:C7))/SUM(COUNTIF(A8:C8,{"dog","horse"}))

FYI, you have a trailing space after dog in A8

**pmdcmatt** · 04-23-2013, 04:42 PM

THANKS! That worked perfect and if I want to add additional conditions it is easy to do so.

**Jonmo1** · 04-23-2013, 04:46 PM

Great, glad to help.

**Tony Valko** · 04-23-2013, 04:53 PM

Here's another one...

Array entered**:

=AVERAGE(IF(A8:C8={"dog";"horse"},A7:C7))

You would be better off using cells to hold the criteria:

A1 = dog
A2 = horse

Array entered**

=AVERAGE(IF(A8:C8=A1:A2,A7:C7))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.