Match, sort and calculate

[Issie_52]

Good day,

Hope you can help me.

I have been using the following formula for years, the the last couple of months it is not working and I have to do it manually. Maybe I've copied something incorrectly or the formula is no longer valid.?

{=INDEX($R$10:$R$2800,MATCH(SMALL(IF(COUNTIF($U234:U$235, $R$10:$R$2800)=0, COUNTIF($R$10:$R$2800, "<"&$R$10:$R$2800), ""), 1), COUNTIF($R$10:$R$2800, "<"&$R$10:$R$2800), 0))}

I am calculating 122 extension number calls per quarter - each month separately and then the total.

It would really really be appreciated if someone can help me.

Thank you.
Windows 11 - Office 365

 

[GraH]

Hi,
Please consider to upload sample data using XL2BB add-on. (see my signature for the link).
It beats pictures. And really simplifies our effort to help you.

PS: If you are on 365, there is no longer a need to use CONTROL+SHIFT+ENTER to confirm array formulas. It's the default behaviour now.