Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

sum ifs with between two dates in excel

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
cookiejest
Asked:
cookiejest
1 Solution
 
barry houdiniCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now