Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT
I have a followinf Formula.
=SUMPRODUCT((DataCustNum=28901)* (DataOrderDate=1/1/2003)* (DataOrderDate<=12/31/2003)* (DataAmount) ) There are some data with blank OrderDate ( for DataOrderDate and DataAmount and DataCustNum). The output is Zero for this formula even though there is data for the criteria specified in the formula. What could be the problem ? Thanks in advance, Shashi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT
Shashi
Instead try: =SUMPRODUCT((DataCustNum=28901)* (DataOrderDate=DATE(2003,1,1)* (DataOrderDate<=DATE(2003,12,31)* (DataAmount) -- Best Regards Leo Heuser MVP Excel Followup to newsgroup only please. "Shashi Bhosale" skrev i en meddelelse ... I have a followinf Formula. =SUMPRODUCT((DataCustNum=28901)* (DataOrderDate=1/1/2003)* (DataOrderDate<=12/31/2003)* (DataAmount) ) There are some data with blank OrderDate ( for DataOrderDate and DataAmount and DataCustNum). The output is Zero for this formula even though there is data for the criteria specified in the formula. What could be the problem ? Thanks in advance, Shashi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT
=SUMPRODUCT((DataCustNum=28901)*
(DataOrderDate=DataValue("1/1/2003"))* (DataOrderDate<=DateValue("12/31/2003"))* (DataAmount)) Might fix it. or =SUMPRODUCT((DataCustNum=28901)* (Year(DataOrderDate)=2003)* (DataAmount)) -- Regards, Tom Ogilvy "Shashi Bhosale" wrote in message ... I have a followinf Formula. =SUMPRODUCT((DataCustNum=28901)* (DataOrderDate=1/1/2003)* (DataOrderDate<=12/31/2003)* (DataAmount) ) There are some data with blank OrderDate ( for DataOrderDate and DataAmount and DataCustNum). The output is Zero for this formula even though there is data for the criteria specified in the formula. What could be the problem ? Thanks in advance, Shashi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct | Excel Worksheet Functions |