Array/Sumifs. Dunno which to use.

[nogstai]

Country Test1 Test2 Test3
MinionTown 78 77 75
Gruville 81 82 80
Gruville 85 86 87
MinionTown 91 88 82
MinionTown 95 90 78
Gruville 82 84 88
MinionTown 88 85 83
Gruville 90 87 79

Hi, I need help on a formula where for example I will get:

Country Test1 Average Test2 Average Test3 Average
MinionTown
Gruville

I need to get the average per country, where the countries are on a row. I don't know which formula to use. Thank you!

EDIT: Ugh, I screwed up the table

[Fotis1991]

Take a look to AVERAGEIF function.

[vlady]

try averageif
for test 1
=averageif(A1:A10,D1,B1:B10) do it to the rest of the Test

A1:A10 -country
D1=name of country to average
d1:d10 list of the test in Test1

[Richard Buttrey]

Hi,

See attached.

Always use simple non array formula wherever possible.