Pull A Value and SUM in a Range based on a Date in Another Range

Hello Everyone!

As usual, thank you for any help you can offer! As you can see in the image I have Dates in A3:L3 that are formatted as "mmm". In A4:L4 I have values depending on the month of the year.

I would like to make it so that when I enter a Date into cell A10 (also formatted as "mmm") that in cell A7 the number will show up only for that month and in E7 the sum of the values up to that month will appear.

Is there a way to do this?

Also, this is not the spreadsheet I'm actually working on or I would just do the SUM and enter the numbers manually.

Thank you and have a wonderful day!

Excel Question.jpg

Disregarding how your cells are formatted.
What are the actual complete values you're entering in A3:L3 and A10 ?
Are they actual dates like 1/1/2013, 2/1/2013?
Or are they just text strings, where you literally type Sep ?

They are dates. Usually I type in something like "02/2013" and it automatically converts to "02/01/2013" but shows up as "Feb".

I can change the formatting of the dates I just thought it would be easier that way.

Originally Posted by Caulerpa

I can change the formatting of the dates I just thought it would be easier that way.

How the cells are formatted doesn't matter.
Because formulas look at the ACTUAL value in the cell, not how the cell is formatted.

In Other words, if A1 is a DATE 1/1/2012
And A1 is formatted as "mmm"
Then =A1="Jan" will be FALSE
Because the actual complete value is still in the cell, it's only "Displaying" the formatted value of Jan.

You are my hero for the day!

Glad it worked out.