When i change 2300,2400 with a cell refernece , excel gives me error.
Please advise.
"Bob Phillips" wrote in message
...
Shashi,

=SUMPRODUCT((DataCustNum={2300,2400})*
(DataOrderDate=Period1Start)*
(DataOrderDate<=Period1End)*
(DataAmount)


--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"Shashi Bhosale" wrote in message
...
=SUMPRODUCT((DataCustNum=A11)*
(DataOrderDate=Period1Start)*
(DataOrderDate<=Period1End)*
(DataAmount)

Above Formula works Great if A11 is having only one value, example 23000

If if my Cell A11 contains 23000, 24000
How i can change my formula to check for both values (23000 & 24000)

Thanks in advance,

Shashi