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