Count number of rows with specific text

R

Rock

I am using this formula to count the number of rows in Column C with text.

=SUMPRODUCT(((LEN(C4:C500)=4)+0)*(ISTEXT(C4:C500)))

I need, instead, for this formula to count the number of rows in Column C
with specific text i.e. the text “PUSHâ€. Can you help?
 
D

Dave Peterson

=countif(c:c,"push")
will count the number of cells in column C that have push in them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Number of Unique Cells That Don't Have Certain Characters 0
formula for arriving net difference 0
What is the "--" (double dash) in MS Excel formula? 2
Hyperlinks with lookups 0
Macro to Select text from a point given to a specific word 2
Macro to select and delete levels of a document 2
Select Text to End of Footnote 9
How to count the numbers in a Word document? 0

Top