SUMIF - Using a date range criteria?

[Jay3]

Hi All,

Can someone tell me if it is possible to use a SUMIF function based on the criteria being between to dates.

i.e. only sum if the date is between the 01/08/2011 to the 10/08/2011?

Thanks
Jay3

 

[wigi]

If these dates are in cells A1 and B1, for instance;

=SUMIF(C1:C10,"<="&B1,"D1:D10")-SUMIF(C1:C10,"<"&A1,"D1:D10")

Change to match your worksheet layout.

 

[Comfy]

=sumifs($b$2:$b$20,$a$2:$a$20,"<10/08/2011",$a$2:$a$20,">01/08/11")

 

[anandvarma]

yes
=SUMIFS($b$1:$b$5,$A$1:$A$5,">"&c3,$A$1:$A$5,"<="&c4)

where b1:b5 is sum range,
a1:a5 is criteria range dates
c1 & c2 hurdle dates

 

[Jay3]

Many thanks )

 

[wigi]

If these dates are in cells A1 and B1, for instance;

=SUMIF(C1:C10,"<="&B1,"D1:D10")-SUMIF(C1:C10,"<"&A1,"D1:D10")

Change to match your worksheet layout.

Typo, apologies. This will work:

=SUMIF(C1:C10,"<="&B1,D1:D10)-SUMIF(C1:C10,"<"&A1,D1:D10)