When I export sales data from my POS system, the date and time of the transaction are combined into one column. I need to sum all the individual sales on a given date, but because of the addition of the time stamp, my SUMIF formula won't work. The date/time data looks like this:
Column B
7/13/2019 16:13
7/13/2019 16:02
7/13/2019 15:48
7/13/2019 15:35
7/13/2019 15:13
To sum all sales that took place on 7/13/19 I tried the following:
=SUMIF(B:B,Q8,H:H)
The dates and times are combined in column B.
The criteria cell is Q8 (which contains the date 7/13/2019)
The sales numbers are in column H
How can I get the formula to look past the time stamps and sum all the 7/13/2019 transactions?
Thanks!
Bookmarks