Getting an average across columns based on criteria.

[anthony1312002]

Hey guys, need your help again. I'm trying to create a formula that will allow me to use the AverageIfs function to get an average across columns.
Here is my formula but it's not working. =AVERAGE(IF((A$44:A$1000=A8)+(D44:D1000=C1),E44:I55))

Based on the Criteria I'm trying to average E:I. Any thoughts?

[JBeaucaire]

The columns ranges must be the same size throughout the formula. Assuming you want to average the values in column E based on specific values matching in columns A and E, the syntax would be:

=AVERAGEIFS($E$44:$E$1000, $A$44:$A$1000, A8, $D$44:$D$1000, C1)

You could try changing the highlighted red to I, not sure what will happen.

[anthony1312002]

Thanks for you input. I tried changing the E to an I making it E$44:I$1000 but it gives me an error message. Why would that be?