Sumifs column time = 00:00

[woon8888]

Hi experts, please help me review the below

=sumifs(A:A, B:B, time(0,0,0))

column B all has date with time but i only wish to sum those with 00:00

 

[Dave Patton]

T202310a.xlsm
	A	B	C	D	E
9	11/11:00	100		365	365
10	11/12:00	150
11	11/15:00	123
12	12/00:00	300
13	12/01:01	400
14	12/00:00	65
2h

Cell Formulas
Range	Formula
D9	D9	=SUMPRODUCT(--(MOD(A9:A14,1)=0),B9:B14)
E9	E9	=SUM((MOD(A9:A14,1)=0)*B9:B14)

 

[woon8888]

Th

So what still appears to be the issue?

View attachment 100187

My original formula, adjusted for you switch of column A & B, for the data sample above:

=SUMPRODUCT(--(A2:A7=INT(A2:A7)),B2:B7)

If something still does not work right, please post a sample of your data, formula, and the output you are getting (and the output you are expecting).

This worked like a charm!

it's my bad previously i am using A:A whole column which didn't work because of the header i guess.