I posted the question a couple of days ago about a SUMPRODUCT formula (excel 2003) for multiple criteria including a range and you guys helped me out with this: =SUMPRODUCT(I9:I1000,(A9:A1000<=9.14)*(A9:A1000>=9.08)*(D9:D1000="Y"))
which worked perfectly.
BUT then I applied it to another set of data in the same worksheet :=SUMPRODUCT(U1:U1000,(A9:A1000<=12.21)*(A9:A1000>=12.15)*(Q9:Q1000="Y")) and all I get is "0" for the result. what did I do wrong?