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