Forum Discussion
Solved
SUMIFS formula not capturing data
I'm trying to pull data from a spreadsheet and it's not pulling like i'd expect.
Formula i'm using is =SUMIFS('Units Shipped'!I:I,'Units Shipped'!A:A,"OREILLY",'Units Shipped'!S:S,D3)
I'm trying to populate the sum of OReilly units shipped the previous day. I think it's not pulling due to how the date is set up on the Units Shipped tab (Nothing I can do about this, it's pulled from an SQL database) but I cant be sure.
Yes because the column S has time those times don't match exactly the date. Easiest solution is just make it check the range for the whole day:
=SUMIFS('Units Shipped'!I:I,'Units Shipped'!A:A,"OREILLY",'Units Shipped'!S:S,">"&D3,'Units Shipped'!S:S,"<"&(D3+1))
Thank you! I knew I was missing something. I Appreciate the help.
Yes because the column S has time those times don't match exactly the date. Easiest solution is just make it check the range for the whole day:
=SUMIFS('Units Shipped'!I:I,'Units Shipped'!A:A,"OREILLY",'Units Shipped'!S:S,">"&D3,'Units Shipped'!S:S,"<"&(D3+1))
