David Stockdale's Scrapcode

Count Cells That Contain A Word In Google Sheets

A simple bit of code that’s worth writing down for counting all cells in a column that contain a specific word/symbol.

Here is an example:

=countif(A2:A, "*Support*")

This simply counts all cells in Column A (except for A1 which I used as a header) which contain the word “Support”.

Hopefully this will make someone’s google search a bit quicker.

Leave a like or a comment if it helped!

Leave a Reply