Using SUMIF to add all data for a given time period

[pbgexcel]

Good afternoon all,

I have a column (P) containing every date from 2010-2017, beside another column (Q) containing an item of data for that date. I want to sum together the data only for January 2011, but my SUMIF always gives '0' (all data is >0 so). Any ideas? This is what I'm working with:

=SUMIF($P$2:$P$52609,AND(MONTH($P$2:$P$52609)=1,YEAR($P$2:$P$52609)=2011),Q$2:Q$52609)

Thanks so much for your help!

 

[Jonmo1]

No, you can't manipulate the date range with any functions in the sumif.
It can only evaluate the date range exactly as it exists.

Instead of thinking like Month = x and year = x,
Think like Between 1/1/2011 and 1/31/2011

=SUMIFS(Q$2:Q$52609,$P$2:$P$52609,">="&DATE(2011,1,1),$P$2:$P$52609,"<="&DATE(2011,1,31))

 

[pbgexcel]

I see. Thanks so much for your help, Jonmo1!

 

[Jonmo1]

You're welcome.