<div>
<div class="content wysiwyg-content">
I have this formula that im trying to make work, its almost there:<br />
<br />
=COUNTIFS( 'Requests RAW'!$O:$O,&quot;&gt;=&quot;&amp;DATE(2011,<wbr />1,1), 'Requests RAW'!$O:$O, &quot;&lt;=&quot;&amp;DATE(2011,1,31),'Requ<wbr />ests RAW'!$L:$L,$J7,'Requests RAW'!$D:$D,$H$4)<br />
<br />
The bit that doesnt work is the part where im trying to make sure the month is in feb 2011. It almost works but for some reason it wont count dates if they are on the first or last day of feb so the count is 1 or 2 away from the actual total as if I were listing results in a pivot table. Any ideas?
</div>
</div>


I have this formula that im trying to make work, its almost there:

=COUNTIFS( 'Requests RAW'!$O:$O,">="&DATE(2011,1,1), 'Requests RAW'!$O:$O, "<="&DATE(2011,1,31),'Requests RAW'!$L:$L,$J7,'Requests RAW'!$D:$D,$H$4)

The bit that doesnt work is the part where im trying to make sure the month is in feb 2011. It almost works but for some reason it wont count dates if they are on the first or last day of feb so the count is 1 or 2 away from the actual total as if I were listing results in a pivot table. Any ideas?

sum ifs with between two dates in excel

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.