Please in a table I'm working on, I have column A for dates and B for values. I want a formular that will check throught the dates and add the corresponding values in B. For example, formular that will add the values in column B between 1/1/2014-31/1/2014. Hope my explanation is clear enough.
Thanks.
Jude.
Last edited by [email protected]; 05-01-2014 at 11:18 PM.
This is exactly what I am trying to figure out as well
=SUMIFS(B:B,A:A,">="&[Reference to cell with start date],A:A,"<="&[Reference to cell with end date])
St_Jude - you show you are using XL2003 and XL2007. This will only work on 2007. Sumifs wasn't available before that release.
One way assuming you're using Excel 2007 or later.
Use cells to hold the date criteria.
D2 = 1/1/2014
E2 = 31/1/2014
Then, this formula:
=SUMIFS(B2:B25,A2:A25,">="&D2,A2:A25,"<="&E2)
Adjust the ranges to suit.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
This is exactly what I needed, it works! thanks!
Originally Posted by xandrew245x
You're welcome. We appreciate the feedback!
This one will work in any version of Excel.
D2 = 1/1/2014
E2 = 31/1/2014
=SUMIF(A2:A25,">="&D2,B2:B25)-SUMIF(A2:A25,">"&E2,B2:B25)
Thanks friends. This worked perfectly for me. Many thanks.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks