I have a date range across row 2, 09/01/2013 through 01/01/2016.
Within the columns per each date range there are numbers. In row 500, I sum the columns / dates.
I need a formula that will allow me to sum a date range say cell B500-X500 (9/1/2013 - 9/30/2013).
Thanks.
There a few ways you could do this.
=sumifs(b500:x500,b2:x2,">="&"9/1/2013",b2:x2,"<="&"9/30/2013")
I'm partial to SUMPRODUCT:
=SUMPRODUCT((b500:x500)*(b2:x2>="9/1/2013")*(b2:x2<="9/30/2013"))
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Take a look at using the sumifS() function. Something like...
=sumifS(B500:X500,$B$1:$X$1,">=9/9/2013",$B$1:$X$1,"<=9/30/2013")
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
edit: is there an echo in here daffodil?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
GMTA. For reals. Echo!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
mphillips 
Register To Reply
Bookmarks