Average Multiple Criteria Single Column

Hello -

I am trying to average a column (Col AA in 2012 proof w SCTL) based on criteria from 2 other columns (Col F and Col B in 2012 proof w SCTL) with one of these columns have multiple criteria in it (Col B in 2012 proof w SCTL, criteria are A and G). The formula that I have tried is copied below but I am getting an error when I hit CTL+SHIFT+Enter or if I just Enter for that matter.

Any help on this would be greatly appreciated.

Thank you in advance!

=average(if(('2012 proof w SCTL'!F:F=1)*('2012 proof w SCTL'!B:B={"A,"G"},'2012 proof w SCTL'!AA:AA))

You've missed a closed parenthesis ) immediately after your closed curly brace:

=average(if(('2012 proof w SCTL'!F:F=1)*('2012 proof w SCTL'!B:B={"A,"G"}),'2012 proof w SCTL'!AA:AA))

It's not a good idea to use full-column references with array formulae - have you thought about using AVERAGEIFS ?

Hope this helps.

Pete