Average with two criteria

[swaink]

Hi All

I am struggling with an average formula and just can't seem to solve it so may I ask for some assistance please.

I am trying to find the average of column Q where C & X meet values in my active sheet (Sheet1) Cell A5 and Cell D2

Column C contains reference numbers some prefixed zero and Column X contains the first four characters of the UK postcode, Column Q contains number values


=AVERAGE(IF('RAW Data'!$C$2:$C$5505=A5,IF('RAW Data'!X2:X5505=D2,""),'RAW Data'!$X$2:$X$5505))

Can you advise where my formula is failing me

Regards

Kevin

 

[Jonmo1]

=AVERAGE(IF('RAW Data'!$C$2:$C$5505=A5,IF('RAW Data'!X2:X5505=D2,""),'RAW Data'!$Q$2:$Q$5505))

Confirmed with CTRL + SHIFT + ENTER

 

[swaink]

Hi jonmo1

Thats work fine and I can now see where I was failing too. Its been a long day

Appreciate your help

Thank you

Kevin