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