Excel - SUM Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula that sums values across a range of dates. for example: Let's say I have Jan - Dec in a row, with corresponding values below. Once I select Jun, the formula should sum up all values from Jan-Jun!
Solved by O. E. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 13/08/2018 - 05:16
Hello, I understand that you need to get the sum of whatever month you choose to January, right?
User 13/08/2018 - 05:16
Excelchat Expert 13/08/2018 - 05:17
Please provide sample data using the sheet to the right.
User 13/08/2018 - 05:18
Yes, if I have a row of dates, e.g Jan - Dec. with corresponding values in the row below. Once I select June, all the values fron January to June are summed up.
Excelchat Expert 13/08/2018 - 05:18
Yes, that's what you posted as the description. Are you able to share a sample data that we can work on?
Excelchat Expert 13/08/2018 - 05:19
I'm asking because this highly depends on how you have your data setup.
User 13/08/2018 - 05:19
Can I type it in the spreadsheet on this screen?
Excelchat Expert 13/08/2018 - 05:19
Yes please.
Excelchat Expert 13/08/2018 - 05:20
Can the dates on top be for the first of the month?
User 13/08/2018 - 05:21
That's the way the data appears...
User 13/08/2018 - 05:21
Yes, ofcourse
Excelchat Expert 13/08/2018 - 05:21
Can you confirm if the dates on top of be 1/1/2018 instead of 1/18/2018?
Excelchat Expert 13/08/2018 - 05:21
Because that would make things a lot simpler.
User 13/08/2018 - 05:22
The dates are 1/1/2018
User 13/08/2018 - 05:23
Hi you there?
Excelchat Expert 13/08/2018 - 05:23
Yes, I'm here. I'm starting to work on your file.
Excelchat Expert 13/08/2018 - 05:23
Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
Excelchat Expert 13/08/2018 - 05:23
PLease give me a few minutes.
Excelchat Expert 13/08/2018 - 05:24
The formula is in B5. A5 is where you can type which month to end the sum.
Excelchat Expert 13/08/2018 - 05:24
For instance, if you type 6/1 in A5, this will sum Jan to Jun
Excelchat Expert 13/08/2018 - 05:24
If you type 12/1 in A5, then it will sum Jan to Dec
User 13/08/2018 - 05:26
Thank you. Ill try it and revert with any questions..
Excelchat Expert 13/08/2018 - 05:26
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert 13/08/2018 - 05:26
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert 13/08/2018 - 05:26
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc