Can anyone please help me with this, i really cant figure it out as i explained

"Bob Phillips" wrote:

=SUMPRODUCT(--(A2:A20=letter_cell),--(B2:B20<0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Lala" wrote in message
...
How can i countif in one cell for two different columns and two different
criteria
i.e.
A B
1 x 1
2 y -0
3 x 2
4 y 9
5 y -1
How can i know how many x are less than 0. and also in case x and y is
text
in a specific cell