=COUNTIF(B:B,"I") counts the number of Y's in col B.
What are you trying to do?

--
Don Guillett
SalesAid Software

"John D" wrote in message
...
I have tried transposing countif for sumif but it doesn't work. I have also
tried
=sumif(A:A,51008,countif(B:B,"Y")) and this causes an error.

"Ben McBen" wrote:

CountIf!

"John D" wrote:

=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question and I
believe that it might benefit what I am trying to do however my column
B is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?