ARRAY CALC

Dear Experts,

                   In the attached sheet, I want to calculate the BLER from "I4" to "AF20"

Now , Logic is for each Carrier ID(Column B), Carrier ID can go from 0~3  only I need to calculate the factor( say BLER here) for each slot( 0~19)-{Column A} && each MCS(0~27)-{Column C).

BLER = Total Count of FAIL / (Total count of FAIL+ PASS), for each Pair of (slot, MCS)

So as an example, for the Cell "I4" so for Carrier ID = 0 , slot-0 & MCS-0, as there's no FAIL so

BLER = 0/(0+19) = 0 ; 19 count of PASS here

we can create a Combo box for Carrier ID ( as only 4 items 0,1,2,3 are there)

Thanks in Advance,

Br,

Anupam