What are the names of the ranges?

Try this:

=SUMPRODUCT(--(Name1="x"),--(Name2="y"))

Replace Name1 and Name2 with your actual named ranges. Note that both named
ranges must resolve to be the exact same size.

--
Biff
Microsoft Excel MVP


"Help with Countif(and" <Help with
wrote in message ...
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".