Try this:

=SUMPRODUCT((JOINED=F273)*(JOINED<=F274)*(ISNUMBE R(SEARCH("INT",JOINED))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"colin_b" wrote in
message ...

Hi David,
I also had them same question. I tried your suggestion and it works
for me, only I need 3 conditions.
I have the following, but it is not working:

=SUMPRODUCT(--(JOINED=F273),--(JOINED<=F274),--(JOINED="*INT*"))

Any assistance would be much appreciated.
Tahnks,
Colin


--
colin_b
------------------------------------------------------------------------
colin_b's Profile:
http://www.excelforum.com/member.php...o&userid=36106
View this thread: http://www.excelforum.com/showthread...hreadid=558799