AverageIf/And combo?

[hallingh]

Hi all. I don't think this is that tough of an issue, but I can't figure out how to make this work. What I want is for a cell to Average the values in K18:K2000 if the corresponding cell in H18:H2000 = "Average" AND the corresponding cell in I18:I2000 = "Q3 2011"

I have it working with just the I18:I2000 criteria by using a simple AverageIf formula:

=AVERAGEIF('Data Archive'!I18:I2007,"Q3 2011", 'Data Archive'!K18:K2007)

But I can't figure out how to factor in the other criteria. Any help you can give me is greatly appreciated.

Thanks!

Hank

 

[Matty]

Hi Hank,

Have a look at the AVERAGEIFS function.

This would appear to fit what you need.

Matty

 

[Greg Truby]

If you have AVERAGEIF(), then you also have the AVERAGEIFS() function.

 

[AD_Taylor]

Could you use the AVERAGEIFS function? Lets you supply multiple criteria to average on. It's only available in Excel 2007 but your signature says you have it so...

See the link below for how to use it properly:
Using AVERAGEIFS

 

[hallingh]

Sweet! Don't know how I was unaware of this function? Anyway, thanks for the help!

Hank