Bob and Frank helped me greatly with a formula based on the SUMPRODUCT
function. I managed to get what they gave me to work fine. Then I messed
with it, and now I need help.

I'm trying to pull my criteria for the ranges from the text values in other
cells. The formula is:
=SUMPRODUCT((NOT(ISERROR(FIND("L5-T",TIR))))*(Dates=20030628)*(Dates<=20040
107)*(CLASS=C4)*(SUBSYSTEM=B5))

where C4 is typed in the cell, and B5=Sheet1!AA1.



Once again, I get a blank - the formula is returning zero. A drop-kick in
the right direction is appreciated!



Ed

(PS - I jumped to a new thread for two reasons: the first one was
apparently resolved early this morning, and the subject of the first one was
"array formula", and I thought getting to SUMPRODUCT would help someone
searching for answers. Hope this didn't screw other things up.)