Sum of the total times a Column has a certain text

Closed
Kawikados - Feb 18, 2016 at 05:11 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 23, 2016 at 11:59 AM
Hello,

I am trying to find the total amount of times that a certain text appears in a column. From A2:A689 I am trying to find the amount of times the words Realty, Automotive, Etc will appear.

Thank you,



Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Feb 23, 2016 at 11:59 AM
hi Kawikados,

Try the following formula:
=COUNTIF(A2:A689,"Realty")

Best regards,
Trowa
0