<div>
Here's one way for any excel version...<br />
<br />
=SUMPRODUCT((A2:A10&gt;=DATE(<wbr />2011,12,1)<wbr />)*(A2:A10&lt;<wbr />=D2),B2:B1<wbr />0)<br />
<br />
assuming dates in A2:A10 and amounts in B2:B10<br />
<br />
In Excel 2007 and later SUMIFS can be used<br />
<br />
SUMIFS(B2:B10,A2:A10,&quot;&gt;=&quot;&amp;<wbr />DATE(2011,<wbr />12,1),A2:A<wbr />10,&quot;&lt;=&quot;&amp;D2<wbr />)<br />
<br />
regards, barry
</div>


Here's one way for any excel version...

=SUMPRODUCT((A2:A10>=DATE(2011,12,1))*(A2:A10<=D2),B2:B10)

assuming dates in A2:A10 and amounts in B2:B10

In Excel 2007 and later SUMIFS can be used

SUMIFS(B2:B10,A2:A10,">="&DATE(2011,12,1),A2:A10,"<="&D2)

regards, barry

<div>
Assuming your dates are A1:A31 and numbers are B1:B31<br />
<br />
=SUMPRODUCT(--((A1:A31&lt;=D2<wbr />)*(B1:B31)<wbr />))
</div>


Assuming your dates are A1:A31 and numbers are B1:B31

=SUMPRODUCT(--((A1:A31<=D2)*(B1:B31)))

<div>
Adding from from barry's suggestion, if you use two cells to specify range of dates ie D1 = Start Date &amp;&nbsp;D2 = End Date:<br />
<br />
=SUMIF(A2:A10,&quot;&lt;=&quot;&amp;D2,B2:B<wbr />10)-SUMIF(<wbr />A2:A10,&quot;&lt;&quot;<wbr />&amp;D1,B2:B10<wbr />)<br />
<br />
Thanks<br />
Rob H<br />

</div>


Adding from from barry's suggestion, if you use two cells to specify range of dates ie D1 = Start Date & D2 = End Date:

=SUMIF(A2:A10,"<="&D2,B2:B10)-SUMIF(A2:A10,"<"&D1,B2:B10)

Thanks
Rob H


<div>
<div class="content wysiwyg-content">
I have date values from Dec1 to Dec31 in one column and number values in the other column next to each date. How do I calculate sum of the number values from Dec 1 up to the date which value equals the date in cell D1? <br />
<br />
example<br />
<br />
12/1/11 &nbsp; &nbsp;30<br />
12/2/11 &nbsp; &nbsp;20<br />
12/3/11 &nbsp; &nbsp; 5<br />
12/4/11 &nbsp; &nbsp; 40<br />
etc.<br />
<br />
If the date in cell D2 is 12/2, then my sum will be 50.<br />

</div>
</div>


I have date values from Dec1 to Dec31 in one column and number values in the other column next to each date. How do I calculate sum of the number values from Dec 1 up to the date which value equals the date in cell D1? 

example

12/1/11    30
12/2/11    20
12/3/11     5
12/4/11     40
etc.

If the date in cell D2 is 12/2, then my sum will be 50.


count values based on date value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.