SUMIF with date & multiple cells

Hi,

I have been trying to get the sum of cells that have a date ranging between 1 jan 2012 and 31 jan 2012 only.

For example:

A1 = 1 jan 2012, A2 = 1 feb 2012
B1 = 1, B2 = 2

I would like to check both A1 and A2, then add the value of only B1 as A2 (so the value of B2) is not between 1 jan 2012 and 31 jan 2012

This command represents what I want to do

Please Login or Register  to view this content.

I wrote 1 to 31 to illustrate the fact I want to check all the day of the months.

Among all the things I have tried, few worked, but only for 1 cell or 1 date.

Spent the last 3 hours of my life on this and checked all the post! Please help me!

Hello fiantee55,

You can use SUMIF like,

=SUMIF(A1:A2;">="&A1;B1:B2)-SUMIF(A1:A2;">"&EOMONTH(A1;0);B1:B2)

Or the below only work XL2007 or later,

=SUMIFS(B1:B2;A1:A2;">="&A1;A1:A2;"<="&EOMONTH(A1;0))

Where A1 is the start Date, will calculate it's end date.