I'm attempting to average values depending upon a category name (using Excel
2007).
I thought this formula would work to average values for Group 1 over the
array B2:E7 but
I'm arriving at an incorrect result - as compared to my manually
calculated average (Avg) below:

The formula I used to attempt the average for Group 1 over the array was:
=AVERAGEIF(A2:A7,"Group 1",B2:E7)

Can someone advise me about what I'm doing wrong? Thank you.

A B C D E Avg Averageif
Group 1 2 1 0 1 1.09 1.33
Group 2 0 0 1 0 0.55 1.00
Group 1 1 1 0 0
Group 2 3 0 1 1
Group 1 1 3 2
Group 2 0 0 0

--
Message posted via http://www.officekb.com