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

# 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
1 Solution

Commented:
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.