How to sum amounts between two dates?

[rbiamonte]

How can I sum amounts in file that fit a specific date range? For example, I am looking to sum amounts from 01/01/2013 thru 03/31/2013. How do I set Excel to pull amounts specific to this date range?

Also, this date range will change at random so I do not want to hard code the dates in the formula.

Thanks,

[JBeaucaire]

Assuming:

1) Dates in column A
2) Values to sum in column B
3) Start date in C2
4) End date in D2
5) Excel version 2007 or greater:

Put this formula in E2:

=SUMIFS(B:B, A:A, "<="&C2, A:A, ">="&D2)

[Tony Valko]

Your profile doesn't indicate what version of Excel you're using.

These formulas will work in any version of Excel.

A2:A20 = dates
B2:B20 = values to sum

Use cells to hold the date criteria:

D2 = 1/1/2013
E2 = 3/31/2013

=SUMIF(A:A,">="&D2,B:B)-SUMIF(A:A,">"&E2,B:B)

=SUMPRODUCT(--(A2:A20>=D2),--(A2:A20<=E2),B2:B20)

When using the SUMPRODUCT function you should avoid using entire columns as range references (which is version dependent).