SUMIFS formula bringing back total of all items, not items in specified date range.

DylanH11

Hello,

I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08 2026. But it continues to total all entries in that column, instead of giving the total based on the provided data.

I've also tried using both OR and AND functions before the date. Using AND returned a 0 for quantity. Where am I going wrong here?

=SUMIFS({Cut Quantity}, {Process}, "TL", {Date}, OR(@cell >= DATE(26, 5, 4), @cell <= DATE(26, 5, 8)))

All dates on the source sheet are in a date specific column as well.

Thanks!

DKazatsky2

Hi @DylanH11 ,

By specifying the year as 26, the system is using the year 1926. You should use the full year to get exactly what you need - 2026. Also, AND is want you want here. Try this.

=SUMIFS({Cut Quantity}, {Process}, "TL", {Date}, AND(@cell >= DATE(2026, 5, 4), @cell <= DATE(2026, 5, 8)))

Hope this helps,

Dave