Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Sumproduct... | Excel Discussion (Misc queries) | |||
SumProduct problem | New Users to Excel | |||
SUMPRODUCT problem | Excel Worksheet Functions | |||
SUMPRODUCT problem | Excel Worksheet Functions | |||
SUMPRODUCT Problem | Excel Discussion (Misc queries) |