COUNT IF AND COUNT A

Closed
ashlyynn Posts 1 Registration date Thursday July 18, 2013 Status Member Last seen July 18, 2013 - Jul 18, 2013 at 05:55 PM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Jul 25, 2013 at 11:35 AM
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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Jul 25, 2013 at 11:35 AM
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