?
Solved

sum ifs with between two dates in excel

Posted on 2011-09-21
1
Medium Priority
?
191 Views
Last Modified: 2012-06-27
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?
0
Comment
Question by:cookiejest
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 36577175
Your quoted formula is counting dates in January not February but I assume your query still applies. Do you have times in with the dates in column O? If so a date/time on 31st Jan will actually be greater than DATE(2011,1,31), try changing to this version using < DATE(2011,2,1)

=COUNTIFS( 'Requests RAW'!$O:$O,">="&DATE(2011,1,1), 'Requests RAW'!$O:$O, "<"&DATE(2011,2,1),'Requests RAW'!$L:$L,$J7,'Requests RAW'!$D:$D,$H$4)

regards, barry
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question