Hi!

Try this:

C1 = 20
D1 = 3ES

=SUMPRODUCT(--(A1:A8=C1),--(B1:B8=D1))

Biff

"JohnHill" wrote in
message ...

I've got 2 columns of data, let's say that they are as follows :-



20 3ES
21 3EM
30 8AS
20 8AS
30 3ES
20 3ES
50 9A
60 9B

I want to count the number of entries wher the values meet two
criteria. The criteria are defined by two cells.

Let's Say I key in 20 in the first look up cell and 3ES in the second
look up cell. The correct answer to the above is 2. That is the first
and the sixth lines meet both criteria.

Help please


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile:
http://www.excelforum.com/member.php...o&userid=25171
View this thread: http://www.excelforum.com/showthread...hreadid=542357