Count cells containing text per row

-
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
See more 

1 reply

Posts
2506
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 8, 2019
356
0
Thank you
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
Respond to TrowaD