ExcelBanter - Count number of rows with specific text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count number of rows with specific text (https://www.excelbanter.com/excel-worksheet-functions/264407-count-number-rows-specific-text.html)

rock

Count number of rows with specific text

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?

Dave Peterson

Count number of rows with specific text

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

Rock wrote:

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?

--

Dave Peterson

rock

Count number of rows with specific text

This is absolutely perfect! Thank you.

"Dave Peterson" wrote:

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

Rock wrote:

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?

--

Dave Peterson
.

All times are GMT +1. The time now is 04:45 PM.