COUNT IF AND COUNT A

Closed
Report
Posts
1
Registration date
Thursday July 18, 2013
Status
Member
Last seen
July 18, 2013
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
I need to count column C if cell equals "medicare" only on the same line column A has text. Column a is made up of names. I just don't need it to count medicare twice when it is listing two cases (column b) to the same patient (column a). (I do not need column b in the equation at all, just a ref point)

COLUMN A COLUMN B COLUMN C

DOLE, BOB ORIF TIB FX MEDICARE
FLUORO MEDICARE

SPEARS, BRIT CTR BXBS
CTS BXBS
FLUORO BXBS

DAD, YOUR SHOULDER SCOPE AETNA
CLAVICLE EXCISION AETNA

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Ashlyyn,

Try using this array formula:
=SUM(IF(A1:A100<>"",1,0)*(C1:C100="Medicare"))
Confirm formula by hitting Ctrl+Shift+Enter.

Best regards,
Trowa
0