COUNTIF Criteria

[GWMO1]

I am tring to do a COUNTIF but the data that I am trying to count is "==>" I am not trying to find greater than or equal to, i need to count exacly "==>" on the sheet I am pulling off of. I read somewhere that ~ can be used before, but it did not seem to work.

=COUNTIF(A2:A10, "==>")

If this is my formula and A2 through A10 had (for example) 5 ==> in the cell, how would i get the formula to count it?

 

[pgc01]

Hi
Welcome to the board

To count cell that contain "==>":

=COUNTIF(A2:A10, "*==>*")

 

[Marcelo Branco]

Hi and welcome to Mr Excel

Try

=SUMPRODUCT(--(A2:A10="==>"))

M.