Average Score with 3 criteria and nested NA in value range

[choongko]

Hi, I am advice on the formula to compute the average score of a test data, based on 3 criteria.  The score range has nested 'NA' together with numeric score values. 

Criteria 1:  Group -  A

Criteria 2:  Test - M2

Criteria 3:  Task ID - 7004

I tried to use "AVERAGEIFS" but  it ended up with error.   I would appreciate it if someone could advise me on the solution for excel 2016 and 365 (for my learning purpose).  I have attached the sample data in this discussion.  Thanks.  

[#2 · Accepted solution]

@choongko 

That's simply

=AVERAGEIFS(G2:G14,B2:B14,K2,E2:E14,K3,D2:D14,K4)

AVERAGEIFS will ignore text values such as "NA".

[#3]

Thanks for your help. I thought I did that earlier, but I got an error. Couldn't figure it out. I tried again, and now it works!!! Must be have been a typo error.