averageifs Issue

[Ironman2]

I am trying to average a set of data from column V to column AE. The data in these columns are pulled using a formula that returns "" if no value is there, so not all cells in this area are populated. I need the columns averageif, based on the 3 criteria, one being whether the name in A:A matches the column header, and if the values in column B are between 2 row headers. I have tried using the formula =AVERAGEIFS(V2:AE520,H:H,">="&AW6,H:H,"<"&AW7,A:A,BC1) where H:H has the values which I want returned between, and A:A has the column header. Whenver I run this formula it returns error. I cannot seem to have any luck with this, can anyone tell me what is causing this issue? If I average with no conditions, it will average just fine.

 

[Tetra201]

Try the following formula (to be entered using Ctrl+Shift+Enter,not just Enter):
Note: lightly tested.

=AVERAGE(IF(($H$2:$H$520>=$AW$6)*($H$2:$H$520<$AW$7)*($A$2:$A$520=$BC$1),$V$2:$AE$520))