SUMPRODUCT Problem
 

Sorry, Gotta do it this way
=-SUMPRODUCT((ChecksC=J5)+(ChecksC=J6)*(ChecksD))
where j5=2300 and j6=2400

"Shashi Bhosale" wrote in message
...
=SUMPRODUCT((DataCustNum={2300,2400})*
(DataOrderDate=Period1Start)*
(DataOrderDate<=Period1End)*
(DataAmount)

The Above Formula works Fine. But When i want to change it to reference a
Cell (A11 contains value 2300, 2400) instead of Hardcoding 2300,2400.

Thanks in advance,

Shashi