I don't have xl97 any more, but =trim() returns a text string. It seems that
those double quotes would be reasonable.

Maybe someone with xl97 would verify--one way or the other.

Shashi Bhosale wrote:

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.

--

Dave Peterson