Jun 29 2021 07:01 AM
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.
Jun 29 2021 07:37 AM
SolutionThat's simply
=AVERAGEIFS(G2:G14,B2:B14,K2,E2:E14,K3,D2:D14,K4)
AVERAGEIFS will ignore text values such as "NA".
Jun 29 2021 07:47 AM
Jun 29 2021 07:37 AM
SolutionThat's simply
=AVERAGEIFS(G2:G14,B2:B14,K2,E2:E14,K3,D2:D14,K4)
AVERAGEIFS will ignore text values such as "NA".