AVerageifs a range of data

If you insert a helper table to determine the condition, it is pretty easy. Take a look at the attached file.

Originally Posted by kent97

In this case is (6+6+3)/3=7

6+6+3 = 15 / 3 = 5

Try this array formula**:

=AVERAGE(IF(C2:G2="U",IF(B3:B7="J",IF(ISNUMBER(C3:G7),C3:G7))))

** 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.

You're welcome!