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.