Summing between two dates

**JakeMann** · 10-29-2013, 11:14 AM

I'm looking for a formula that sums up values between two dates,

for example -

Column A has dates from 01/10-31/10
Column B has the values.

How would I do it? SUMPRODUCT?

**Moo the Dog** · 10-29-2013, 11:25 AM

You could try:

=SUMPRODUCT((A1:A100>=DATEVALUE("01/10/2013"))*(A1:A100<=DATEVALUE("07/10/2013"))*(B1:B100))

That would give you the values from column B where the dates in column A are between 01/10 and 07/10.

You could also use SUMIFS (since you have Excel 2010):

=SUMIFS(B:B,A:A,">="&DATEVALUE("1/10/2013"),A:A,"<="&DATEVALUE("7/10/2013"))

- Moo

* Modified formulas so that they actually work =)

**JakeMann** · 10-29-2013, 11:47 AM

Nice one Moo. That's worked a treat, thanks

**Moo the Dog** · 10-29-2013, 12:34 PM

JakeMann,

Glad to be of assistance! =)

If you have the time, feel free to click on the "* Add Reputation" link at the lower-left corner of one of my posts. It's always appreciated!

- Moo