Year and Month Question?

M

Michael168

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$1000:$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
 
F

Frank Kabel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Year and Month Question? 1
Year and Month Question? 2
HELP WITH SUMPRODUCT FORMULA USING YEAR() and MONTH() FUNCTIONS 5
days and months with heading zero from formula 2
graph by month/year a count of a list of dates 1
How to pick date and month? 3
Month and year programmatically in a cell? 9
SumProduct by specific weeks of the month or year 2

Top