Previous Topic Next Topic

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 Contributor 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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses