Average in a Countifs function help help it's driving me mad!!

[Melmillw82]

Hi all, i have a formula that counts with certain criteria. =sum(countifs($AH:$AH,{"JAN","FEB","MAR"},$AT:$AT,A9,$BE:$BE,"RETAIL")) I want to use the same criteria but I also need an average of column CK:CK but only if it meets the above criteria. It been driving me crazy! ? thanks in advance.

 

[shg]

Maybe ...

= SUM(SUMIFS(CK:CK, $AH:$AH, {"JAN","FEB","MAR"}, $AT:$AT, A9, $BE:$BE, "RETAIL")) 
/ SUM(COUNTIFS(     $AH:$AH, {"JAN","FEB","MAR"}, $AT:$AT, A9, $BE:$BE, "RETAIL"))

 

[Melmillw82]

Does it matter that the column I am trying to get the average for is a %?

 

[shg]

Nope.