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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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