Forum Discussion

Rodney2485's avatar
Rodney2485
Brass Contributor
Mar 27, 2025
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...
excel
Formulas and Functions
office 365
  • m_tarler's avatar
    m_tarler
    Mar 27, 2025

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

     

m_tarler's avatar
m_tarler
Bronze Contributor
Mar 27, 2025

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

 

Resources