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 January 16, 2023 - Aug 6, 2019 at 11:56 AM

Hello,
I am trying to figure out and if statement to add 1 if there is text in a row so that at the end of the row I will get a total for each time there is text noted in a row.

Would appreciate any help!

System Configuration: Macintosh / Chrome 75.0.3770.100

Count cells containing text per row
Excel create unique id for each row ✓ - Excel Forum
Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
Hide subscriber count - Guide
Saints row 2 cheats - Guide
Count sentences ✓ - Programming Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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

Similar discussions

Counting cells containing only numbers

Condition formatting on changing cell color based on another cel

Excel - IF function with multiple words

How to use conditional format based on text?

help me to add particular cells

Similar discussions

Subscribe To Our Newsletter!