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?
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?
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 =)
Last edited by Moo the Dog; 10-29-2013 at 11:43 AM.
Nice one Moo. That's worked a treat, thanks
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks