Comments on: An Easy Google Sheets Count Cells with Text Guide for 2024 https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/ Google Sheets Tips & Tutorials Wed, 06 Mar 2024 15:54:32 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: Christopher Daniel https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-10710 Wed, 14 Dec 2022 03:12:50 +0000 https://spreadsheetpoint.com/?p=1017#comment-10710 In reply to Gabriele.

When typing the formula, click the cell C3 instead of typing it and don’t use quote marks.

]]> By: Arjo https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-10481 Sat, 29 Oct 2022 12:10:07 +0000 https://spreadsheetpoint.com/?p=1017#comment-10481 I am curious if it is possible to make the reference in the last part in the formula for searching for a part of the cell value (usings the wild cards) could be relative.

For example: i have a number of cells which I want the formula to check for:
B2: V C2: M D2: A E2: w

So I would the formula to check for the value in cell E2:
=COUNTIF(A2:A13,”*mark*”) would then become: =COUNTIF(A2:A13,E2)

But obviously, that doesn’t work as the wildcard/asterix is not present. So I made this:
=COUNTIF(A2:A13,””*””&E2&””*””) but that also does not work.
I tried to use the textjoin formula. But that also doesn’t seem to work.

Is it possible to use a relative cell reference combined with the asterix/wildcards to search for a specific string in a part of the matrix/cells?

]]> By: Matt C. https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-10473 Thu, 27 Oct 2022 08:52:15 +0000 https://spreadsheetpoint.com/?p=1017#comment-10473 In reply to Rashmi.

What if I want to count the number of times Mark appeared in a cell? Say example cell a1 contains mark / matt / alex / mark / jonathan / mark – this would ideally say 3 counts of mark, but using your formula, it would only count as 1 as they are in the same cell.

]]> By: Gabriele https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-9887 Fri, 15 Jul 2022 09:42:57 +0000 https://spreadsheetpoint.com/?p=1017#comment-9887 Hey Sumit, thanks for this post. What if instead of counting a simple text value I want to count how many occurrences of a text that is contained in a cell?

I tried =COUNTIF(A:A,”*A2*”) but it doesn’t work, Thank you

]]> By: Ch. Umar Meraj https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-9231 Thu, 31 Mar 2022 12:41:34 +0000 https://spreadsheetpoint.com/?p=1017#comment-9231 Helpful, but I’m looking for some other scenario like if I have a list of cities in the 1st column and the 2nd one contains multiple reasons.
Now I want to calculate all the data (from multiple sheets) on the main sheet containing Cities in column A and Reasons in columns B, C, D, E & F.

]]> By: Gabriele https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-8797 Wed, 02 Mar 2022 09:58:32 +0000 https://spreadsheetpoint.com/?p=1017#comment-8797 Thank you, this is useful. What if instead of expliciting the text inside the second argument I want to refer to a cell?

e.g. in C3 I have “Salad” and I want to count all cells in that range containing *C3* that I know migh change.

It doesn’t work with the cell.

]]> By: Rashmi https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-7984 Wed, 05 Jan 2022 02:09:54 +0000 https://spreadsheetpoint.com/?p=1017#comment-7984 Great.. Thanks

]]> By: Carlos Alberto Teixeira https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-6066 Sat, 28 Aug 2021 18:16:25 +0000 https://spreadsheetpoint.com/?p=1017#comment-6066 👍 🖖]]> Splendid and perfect instructions. Thanks a 1,000! And greetings from Niterói, Rio de Janeiro, Brazil ❤️️ 👍 🖖

]]> By: Narendra https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-3840 Sat, 20 Mar 2021 15:55:33 +0000 https://spreadsheetpoint.com/?p=1017#comment-3840 Hi!,

I have a question related with the above as I have a data like below and want to find the unique count. Can you pls help me out to get this done? Pls see the data below. I want to get the unique value of students who have eaten Apple OR Grapes. What would be the formula?

Students Fruits
A Apple
B Apple + Grapes
C Orange
D Banana
E Apple + Grapes
F Grapes

Narendra

]]> By: John https://spreadsheetpoint.com/count-cells-with-specific-text-in-google-sheets/#comment-3571 Thu, 04 Mar 2021 02:27:08 +0000 https://spreadsheetpoint.com/?p=1017#comment-3571 Thank you

]]>