Previous Topic Next Topic

Count cells containing text per row

Solved/Closed
Blocked Profile - Updated on Jul 23, 2020 at 11:23 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 22, 2020 at 11:43 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!

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


1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 22, 2020 at 11:43 AM
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

0

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses