Need assistance with a calculation that involves a date range.

[markman235]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am trying to get a sum to calculate if it fall within a date range. <o></o>
<o> </o>
For example:<o></o>
<o> </o>
A1:A100 are dates in the format of 1/1/2011 and B1:B100 is the total number of units that was produced on that date.<o></o>
<o> </o>
I would like to create a formula that will look in column A for all the dates in February and then give the total sum for everything in column B that matches the date in February. <o></o>
<o> </o>
I have tried using IF, SUMIF, SUMIF(AND, and SUMPRODUCT formulas, but can’t quite get it to work. <o></o>
<o> </o>
Any suggestions?<o></o>
<o> </o>
Thanks, <o></o>
<o> </o>
Mark<o></o>

 

[jmthompson]

if you have 2007-

=SUMIFS(B:B,A:A,">1/31/2011",A:A,"<3/1/2011")

 

[markman235]

Jen, you are my hero!!!!

I have Excel 2010, and this formula works perfectly!!!!

Thank you!