Hi Ed, Bob
I just posted Ed a corrected version of his spreadsheet. Besides the
issue Bob mentioned regarding the FIND function, the date columns did
not contain dates but real numbers (e.g. 20030101). So both our date
comparisons didn't work -as it could be exspected in this case :-).
So after changing this and correcting the FIND function SUMPRODUCT
works

Regards
Frank

Bob Phillips wrote:
Ed,

You still have the * in the first test. Both mine and Frank's formula
used ISERROR(FIND to circumvent this. Try this formula


=SUMPRODUCT((NOT(ISERROR(FIND("L5-T",TIR))))*(DATES=DATE(2003,6,28))*(
DATES
<=DATE(2004,1,7))*(FDSC_CLASS="EFF")*(CHARGEABILIT Y="HARDWARE/CFE"))


"Ed" wrote in message
...
No! The *formula* didn't give me that - my manual AutoFilter count
did. The formula *Still* shows blank. Any ideas?

Ed

"Frank Kabel" wrote in message
...
Hi Ed
good to hear.
Frank

Ed wrote:
Okay - hit the button too soon! The XX value in the previous post
is 139 values that match.

Ed