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

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

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