Hi! Frank Kabel

Thanks for your help. One more question for you.

If I assign say "Aug" in column "B1". How do I quote in the formula s
that it understand that it is equal to 8.

e.g. like this (Month(Full!$A$1000:$A$2000)=B1)

Thanks
Michael

Frank Kabel Wrote:
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




--
Michael16
-----------------------------------------------------------------------
Michael168's Profile: http://www.excelforum.com/member.php...info&userid=60
View this thread: http://www.excelforum.com/showthread.php?threadid=27449