How to sum based on a given date

[mart_mrexcel]

I have a heading date from d2 to O2 (ie. Jan 31 2016 - Dec 31 2016)and it has a value in each date located at cell D3 to O3. How can I sum the total based on a given date. Example if I put July 31 2016, it will sum from Jan - July 31 only

 

[Mathias Pedersen Heinze]

Hi. You need to elaborate on at least the following three questions in order for us to help you:

(i) Are the dates in D2:O2 entered as date values, i.e. ‘Jan 31 2016’ = 42400, or are they entered as plain text, i.e. "Jan 31 2016"?

(ii) Should the summation always start from the very first date in the range, i.e. D2 (no matter what date value it has)?

(iii) What if the given date falls between two dates in the D2:O2, should the sum then include the previous or the following date?

 

[etaf]

do you always want to sum from 1st jan 2016
use a sumifs()

=SUMIFS(D3:O3,D2:O2,">="&DATEVALUE("1/1/16"),D2:O2,"<="&DATEVALUE("1/7/16"))

or you can use a cell to put the "to" date

 

[mart_mrexcel]

D2:O2 entered is always D2:O2 entered

 

[etaf]

Sorry, I don't understand your post

 

[Aladin Akyurek]

A2: 2016-07-31

In B2 enter:

=SUMIFS($D3:$O3,$D$2:$O2,"<="&$A2)

which essentially what etaf also suggests.