=SUMPRODUCT(--(A1:A100&B1:B100="xy"))

Caveat about using a formula like that:

x.....y
b....o
.......xy
c....y

The above formula would return 2. If your data may present this situation
and you want to use a formula like that concatenate a unique character that
will not appear in your data:

=SUMPRODUCT(--(A1:A100&"~"&B1:B100="x~y"))

--
Biff
Microsoft Excel MVP


"Teethless mama" wrote in message
...
All versions Excel:
=SUMPRODUCT(--(A1:A100&B1:B100="xy"))

Excel 2007 only:
=COUNTIFS(A:A,"x",B:B,"y")


"Help with Countif(and" wrote:

I'm trying count how many times the value from one cell equals those
cells in
a defined range and another cells equals the values in another defined
range.

So I want to count the number of occurences where the a cell in column
A="X"
and the cell in column B in the same row = "Y".