I am using Excel 2003.

I think this formula use to work fine in Excel 97 but doesn't not work with
2003.

=SUMPRODUCT((TRIM(DataCustNum)={24103,24102})*

(DataOrderDate=Period1Start)*

(DataOrderDate<=Period1End)*

(DataAmount)

)

This also dont work fine but when i put quotes ("") for 24103 it works. I
think both these examples worked fine in Excel 97

=SUMPRODUCT((TRIM(DataCustNum)=24103)*

(DataOrderDate=Period1Start)*

(DataOrderDate<=Period1End)*

(DataAmount)

)

Please help.