Count cells containing text per row [Closed]

Report
-
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
-
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

1 reply

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!