Count cells that contain text

[jeff7]

I would like to count all the values in column A that match the ">10" in cell B1. I don't want to count all the values less than 10. Rather, I want to count the number of cells that match the exact text ">10". How would I write this formula?

Thanks for your help.

Jeff

[Tony Valko]

If I understand what you want to do...

=SUMPRODUCT(--(A1:A10=B1))

[jason.b75]

Or

=COUNTIF(A1:A10,"="&B1)

[mahju]

Also try to match the text and not compare values

=COUNTIF(A1:A10,"*>10" )

It will count the number of cells containing ">10" so there should be no value containing ">10" e.g. "aa>10", ">10ss55" or "dd>10pp"

Regards

[jason.b75]

Also try to match the text and not compare values

That is what Tony and myself have already done, without the possibility of incorrect results if the criteria matches part of a longer text string.

Sumproduct will evaluate ">10" as a text string, not as values greater than 10.

Using countif, "="&B1 gives a criteria string of "=>10" which looks for values equal to ">10" not values that are greater than or equal to 10. The function can be tricked by using < = and > in less conventional ways.