SUMIF - dates, ignore times?

[MOB]

List of dates in a column, some have times, some do not. I think the ones that do not are due to the time being 00:00?

I want to use a SUMIF looking at that column, but looking only at the dates.

Is this possible? At the moment the user uses text to columns to split out the time into the next column, but I'd rather eliminate this step if possible.

Many thanks

 

[RossTattersall]

Use SUMIFS and do something to the effect of

=SUMIFS([SumRang], [daterange], ">=" Day, [daterange], < Day + 1)

So sum everything after 00:00 on your day, but before the next day (so everything from that day)

 

[steve the fish]

You can using SUMIFS. Greater than or equal to the date and less than the date +1.

 

[AhoyNC]

Maybe another option to use SUMPRODUCT:

Excel Workbook
	A	B	C	D	E
1	Date / Time	Value
2	5/6/2019	100		Date	Sum
3	5/6/2019 10:00	101		5/8/2019	103
4	5/6/2019 14:00	102
5	5/8/2019	103
6	6/12/2019	104
7	6/12/2019	105
8	6/12/2019 4:00	106
9	6/17/2019	107
10	6/17/2019 16:00	108
Sheet

 

[MOB]

Thanks all - ended up using sumproduct