Solved

sum ifs with between two dates in excel

Posted on 2011-09-21
1
182 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 500 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

717 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