Count cells containing text per row [Solved]

Report
-
Posts
2727
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 20, 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!

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------


1 reply

Posts
2727
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 20, 2021
459
Hi Thelearnlaxi,

When you want to count all cells with something (text or numbers) in them, use:
=COUNTA(A1:Z1)

When you want to count all cells with only text (combination of text and numbers is considered text) in them use:
=COUNTIF(A1:Z1,"*")

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!