**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

Hi..

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.*