Three way array function
 

Are these possible?
I've got the following formula to work out how many instances there are
of "Apples" and "COM" occuring at the same time

{=COUNT(IF((leasetracker!$E$2:$E$2000="Apples")*(l easetracker!$H$2:$H$2000="COM"),leasetracker!$A$2: $A$20000))}

I want to work out how many times they occur between two dates. (They
would be in column Z

Many Thanks


--
M3Cobb
------------------------------------------------------------------------
M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986
View this thread: http://www.excelforum.com/showthread...hreadid=545888