Shashi,

Put 2300 in A11, 2400 in B11, and use

=SUMPRODUCT((DataCustNum=A11:B11)*
(DataOrderDate=Period1Start)*
(DataOrderDate<=Period1End)*
(DataAmount)

--

HTH

Bob Phillips

"Shashi Bhosale" wrote in message
...
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