What exactly is in E238 and E239 ?
Are they dates?
Perhaps they actually contain a TIME value as well.
Try
=SUMIFS(N$3:N$139, $A$3:$A$139, "Bitterne", $E$3:$E$139, ">=" &INT($E238), $E$3:$E$139, "<" &INT($E239))
What exactly is in E238 and E239 ?
Are they dates?
Perhaps they actually contain a TIME value as well.
Try
=SUMIFS(N$3:N$139, $A$3:$A$139, "Bitterne", $E$3:$E$139, ">=" &INT($E238), $E$3:$E$139, "<" &INT($E239))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks