Working out the average after checking a column

**Cmorgan** · 11-07-2011, 04:38 PM

Evening,

I would appreciate any help you can give, please:

I want to work out the average of column AA, if the value in E1065 is in column B.

Thanks for the help.

**NBVC** · 11-07-2011, 04:47 PM

Try:

=Averageif(B:B,"E1065",AA:AA)

**Cmorgan** · 11-07-2011, 05:08 PM

Thanks, this works a treat, I just need to amend it for the following:

=AVERAGEIF('KS3 Figs'!D:D,E1076,'KS3 Figs'!AA:AA)

But instead of column D having the figure in E1076, it must NOT have the value in E1076.

Any ideas, please?

**NBVC** · 11-07-2011, 05:20 PM

Try:

=AVERAGEIF('KS3 Figs'!D:D,"<>E1076",'KS3 Figs'!AA:AA)

**Cmorgan** · 11-07-2011, 05:28 PM

Sorry, another problem I've now been told I need to check another column, so... I am using:

=AVERAGEIF('KS4 Figs'!D:D,E1106,'KS4 Figs'!AA:AA)

This is working out the average of column A, if the value of E1106 is in column D.

But what I now need to do is use this but also to check that not only E1106 is in column D, but also that B1104 is in colum F.

Any ideas please?

Cheers