Hi,

the first part

=SUMPRODUCT((A1:A5="x")*(B1:B5<0))

and also in case x and y is text
in a specific cell

I don't understand this bit. What answer do you expect to get from the
posted data?

Mike


"Lala" wrote:

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