ExcelBanter - help with sumproduct function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - help with sumproduct function (https://www.excelbanter.com/excel-programming/340078-help-sumproduct-function.html)

help with sumproduct function

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.

help with sumproduct function

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