<div>
Hi, <br />
if you don't get result from FarWest solution try this simple:<br />
<br />
=SUMIFS(B1:B24,A1:A24,&quot;&gt;=&quot;<wbr />&amp;C2, A1:A24, &quot;&lt;=&quot;&amp;D2)<br />
<br />
-FA
</div>


Hi,
if you don't get result from FarWest solution try this simple:

=SUMIFS(B1:B24,A1:A24,">="&C2, A1:A24, "<="&D2)

-FA

<div>
sorry correct comparing cells<br />

<pre><code id="code-20-40694734-1">=SUMIFS(B3:B20,A3:A20,CONCATENATE(&quot;&gt;=&quot;,TEXT(C2,&quot;yyyy-mm-dd&quot;)),A3:A20,CONCATENATE(&quot;&lt;=&quot;,TEXT(D2,&quot;yyyy-mm-dd&quot;)))</code></pre>
</div>


sorry correct comparing cells


=SUMIFS(B3:B20,A3:A20,CONCATENATE(">=",TEXT(C2,"yyyy-mm-dd")),A3:A20,CONCATENATE("<=",TEXT(D2,"yyyy-mm-dd")))

<div>
I'm confused; you posted this to the Access topic area. &nbsp;Did you want to do this in Access? &nbsp;In Access, you would normally use the values in the first row of the spreadsheet as column headers. <br />
<br />
Is this Excel file linked to Access? &nbsp;<br />
<br />
Did you really mean in between C2 and D2, or did you mean between the data in the relevant row of the C and D columns?
</div>


I'm confused; you posted this to the Access topic area.  Did you want to do this in Access?  In Access, you would normally use the values in the first row of the spreadsheet as column headers.

Is this Excel file linked to Access?  

Did you really mean in between C2 and D2, or did you mean between the data in the relevant row of the C and D columns?

<div>
<div class="content wysiwyg-content">
Column A has a list of dates. Column B has a list of values I want to add.<br />
<br />
If the date is inbetween the date in C2 and D2 (including the dates of C2 and D2) then I want it to sum the value in Column B.<br />
<br />
Any idea how to write this sumif code?<br />
<br />
Thanks!
</div>
</div>


Column A has a list of dates. Column B has a list of values I want to add.

If the date is inbetween the date in C2 and D2 (including the dates of C2 and D2) then I want it to sum the value in Column B.

Any idea how to write this sumif code?

Thanks!

Sumif inbetween dates

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.