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 December 27, 2022 - 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
Saints row 2 cheats - Guide
How to count names in excel - Guide
How to delete a row in a table in word - Guide
Count sentences ✓ - Programming Forum
Conditional formatting if cell contains text - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

help me to add particular cells

Fill adjacent cell with number from text answer

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!