Welcome!

Counting Occurence of String of Text in a Column

Hi,

I need suggestions on how to count string of text on a column. For example, i need to count how may GRC are there on the sample below:

GRC

Aer, GRC

Aer, CDIR, GRC

HTM

etc.

Thank you!

Formulas

=COUNTIF([Column1]:[Column1], FIND("GRC", @cell) > 0)

Awesome! thank you for saving me the trouble!

Follow up question; if I find "GRC" in the above example and wanted to automatically check a checkbox column, what would the formula be?

Just a simple if statement inside of the checkbox.

If([Output from previous formula]1>0,1,0)

INDEX/MATCH with the range on MATCH is multiple columns
I have one sheet that is tracking PTO where a user has entered the days off. The form allows them to enter a start and end date for their PTO and enters a single record into the sheet. I have a second sheet that I am looking to pull that data into, but there is only one record per person (column in this sheet where the…
I am trying to add the number of passengers per month per year
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
Formula Wormhole - Count ifs distinct with multiple range requests
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…