You're trying to compare a 1 dimensional array, A2:A7, to a 2 dimensional
array B2:E7. So, you're formula:

=AVERAGEIF(A2:A7,"Group 1",B2:E7)

Was working as though it was written like this:

=AVERAGEIF(A2:A7,"Group 1",B2:B7)

Try this array formula** :

=AVERAGE(IF(A2:A7="Group 1",IF(ISNUMBER(B2:E7),B2:E7)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"GB3 via OfficeKB.com" <u57077@uwe wrote in message
news:a1faa0351db22@uwe...
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