Count cells containing text per row
Closed
c
-
Updated on Aug 6, 2019 at 11:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 6, 2019 at 11:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 6, 2019 at 11:56 AM
Related:
- Count cells containing text per row
- Saints row 2 cheats - Guide
- How to count names in excel - Guide
- How to delete a row in a table in word - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 6, 2019 at 11:56 AM
Aug 6, 2019 at 11:56 AM
Hi C,
No need for if statements as Excel already got a function for that:
=COUNTIF(A1:M1,"*")
This will count the number of cell within the specified range that contains TEXT (so no numbers).
Best regards,
Trowa
No need for if statements as Excel already got a function for that:
=COUNTIF(A1:M1,"*")
This will count the number of cell within the specified range that contains TEXT (so no numbers).
Best regards,
Trowa