I am trying to calculate a total count with in a certian criteria. I have 4 Columns.
Report: Yes or No
Health Plan: Listing health Plans
Contracted: Yes or No
Final Disposistion: Uphold But Pay By Exception and Upheld by Utilization Management Committee
I am trying to set a criteria of Reports that will list Reports as yes under a certain health plan with a Contract Status of Yes and with a Final Disposistion of Uphold But Pay By Exception and Upheld by Utilization Management Committee
I am getting a value of zero when using the following formula.
=SUMPRODUCT(--(A1:A15="Yes"),--(B1:B15="Blue Cross MediCal"),--(G1:G15="No"),--(I1:I15="Uphold But Pay By Exception"),--(I1:I15="Upheld by Utilization Management Committee"))
Any suggestions?
Thanks in advance,
Brian