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
Count occurrences in excel - Guide
How to delete a row in a table in word - Guide
Based on the cell values in cells b77 - 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

help me to add particular cells

Condition formatting on changing cell color based on another cel

Fill adjacent cell with number from text answer

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!