Excel 2003

This is the formula I have:
=SUMIF((INDEX(QM2S1,,2)),"2-MAKE READY"*INDEX(QM2S1,,3,B2),INDEX(QM2S1,,28))

What I want it to do is - if the second column of range QM2S1 = 2-MAKE
READY, and the third column of range QM2S1 = B2 (date), then sum the 28th
column of range QM2S1.

I've tried both SUMIF (no result), and SUMPRODUCT (# VALUE) result.

TIA,
Carole O