Month Average

[pjandshelly]

I am looking to create a formula where on the top row, I have dates for each day of the week from 10/1/17 through 9/30/18. In the first Column, I have Service Areas. My data is different counts. In one data set, I am pulling just counting numbers. In another set, I am pulling a percentage calculation. For example, Calls Presented, Calls Handled, Percentage Abandonment Rate (Calls Handled/Calls Presented). I want to know Average Calls Presented, Average Calls Handled, Average Calls Abandoned for each month. I used a previous formula that I got from a previous thread where it was pulling a total number of the Sum of these values, but it didn't work for averages. This was my Sum Formula:
{=SUM(IF(ISNUMBER(MATCH($A$2:$A$33,{2200,2210,2220,2230,2240,2250,2400,2410,2420,2430,2440,2450,"B100","B120",8150},0)),IF($B$1:$BI$1-DAY($B$1:$BI$1)+1=I$44+0,$B$2:$BI$33)))}

Average Formula:
{=Average(IF(ISTEXT(MATCH($A$2:$A$33,{"CALL CENTER"},0)),IF($B$1:$NE$1-DAY($B$1:$NE$1)+1=E$66+0,$B$2:$NE$33)))}

Can someone point me to the error of my ways.

 

[BiocideJ]

It is a somewhat complicated formula without the underlying data to help along, but one thing I notice right off the top is you are checking ISTEXT(MATCH, however, MATCH will never return text. It will always return a number indicated a row (or series of rows in an array formula) within the defined range.

Try switching that to ISNUMBER and see if that cleans it up.