Sum of the total times a Column has a certain text

Closed
Kawikados - 18 Feb 2016 à 17:11
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Feb 2016 à 11:59
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
23 Feb 2016 à 11:59
hi Kawikados,

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

Best regards,
Trowa