Hi!

Can someone guide me how to use the Year and Month functions? I have a
formula below which gives me wrong answer.

=SUMPRODUCT((Full!$K$1000:$K$2000=2)*(Full!$AD$100 0:$AD$2000=1)*(Month(Full!$A$1000:$A$2000=8)*(YEAR (Full!$A$1000:$A$2000=2002)))

Without using Year and Month the answer is correct. The format of date
is "dd/mm/yyyy"

Can someone show me what mistake I have made?

Thanks
Michael


--
Michael168
------------------------------------------------------------------------
Michael168's Profile: http://www.excelforum.com/member.php...nfo&userid=605
View this thread: http://www.excelforum.com/showthread...hreadid=274495

Hi
try:
=SUMPRODUCT((Full!$K$1000:$K$2000=2)*(Full!$AD$100 0:$AD$2000=1)*(Month(
Full!$A$1000:$A$2000)=8)*(YEAR(Full!$A$1000:$A$200 0)=2002))

--
Regards
Frank Kabel
Frankfurt, Germany


Michael168 wrote:
Hi!

Can someone guide me how to use the Year and Month functions? I have
a
formula below which gives me wrong answer.


=SUMPRODUCT((Full!$K$1000:$K$2000=2)*(Full!$AD$100 0:$AD$2000=1)*(Month(
Full!$A$1000:$A$2000=8)*(YEAR(Full!$A$1000:$A$2000 =2002)))

Without using Year and Month the answer is correct. The format of
date
is "dd/mm/yyyy"

Can someone show me what mistake I have made?

Thanks
Michael