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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 25, 2013 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 25, 2013 at 11:35 AM
Related:
- COUNT IF AND COUNT A
- Hide subscriber count - Guide
- How to count names in excel - Guide
- Count number of occurrences in excel - Guide
- How to count how many times a number appears in excel ✓ - Excel Forum
- Given a sentence write a program to count the number of palindrome words in it in c - Programming Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jul 25, 2013 at 11:35 AM
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
Try using this array formula:
=SUM(IF(A1:A100<>"",1,0)*(C1:C100="Medicare"))
Confirm formula by hitting Ctrl+Shift+Enter.
Best regards,
Trowa