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 December 27, 2022 - Jul 25, 2013 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 25, 2013 at 11:35 AM
Related:
- COUNT IF AND COUNT A
- How to count names in excel - Guide
- Do chats count towards best friends on snapchat 2023 - Guide
- Count occurrences in excel - Guide
- Youtube subscriber count - Guide
- Count in french excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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