Inequalities referencing cells

Hello,

I have the formula below:

=SUMIFS(N$3:N$139, $A$3:$A$139, "Bitterne", $E$3:$E$139, ">=" &$E238, $E$3:$E$139, "<" &$E239)

I want it to sum when cells E3 to E139 are E238<=x<E239 but it appears to be returning E238<=x<=E239. It works properly when I put the number in rather than the cell reference but I have lots of numbers! Any ideas what I've done wrong/how to fix this?

Thanks

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))

They are times, yes. I tried what you suggested but it didn't work. I tried changing all the cell formats to numbers instead of times but that didn't work either :/

If they're TIMEs, then INT was the wrong way to go.
Testing times for < or > is tricky.
Especially if you're wanting to look at only the hour and/or minute, but ignore the seconds.
If you have your cells formatted to show only hh:mm, the seconds value is still actually there.
So if say E239 is 7:30:15, but shown formatted as only 7:30
A cell in E3:E139 that is 7:30 would actually qualify as < 7:30:15

Might help if you posted a sample copy of the file
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic