Menu
Ask a question Report

Count cells containing text per row

-
Excel Ask a question Report
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

Report Respond to TrowaD
Posts
2519
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 3, 2019
 361
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
Reply Ask a question