Date criteria in SUMIFS formula

[kins]

hi all

I have the below formula which looks at two date ranges and brings back values within that date range. The issue that I'm having is that "<="&$C$13 part isn't bringing back the last line in my date range i.e. it won't return the value in the 24/04/2017 00:00 one unless I type 24/04/2017 00:30.

=SUMIFS(V34:V17553,$B$34:$B$17553,"<="&$C$13,$B$34:$B$17553,">="&$C$9)

Can anyone help?

Thanks,

Kins

 

[Jonmo1]

Try

"<"&$C$13+1

 

[wideboydixon]

Maybe you have a time component in one or more of your cells. Try this instead:

=SUMIFS(V34:V17553,$B$34:$B$17553,"<"&INT($C$13+1),$B$34:$B$17553,">="&INT($C$9))

WBD

 

[kins]

thanks both, I'll give this a try.

Thanks for changing the title, admin.