Sumif Same Hour Hour

[ajamess]

If I have a list of Times in Column A and values in Column B. Can I perform a sumif on column B for times in a Certain hour in column A.

Something like:

=sumif(a:a,hour(a:a) = x, b:b)

Or I would need to do either a helper column that is =hour(a2) and drag down, or do sumifs(b:b, a:a, ">=" & time(x,0,0), a:a, "<" & time(x+1,0,0))

 

[barry houdini]

You can use SUMIFS like this for times in hour 10

=SUMIFS(B:B,A:A,">=10:00",A:A,"<11:00")

adjust as required or you can put 10:00 in a cell, e.g. D2 and use this version


=SUMIFS(B:B,A:A,">="&D2,A:A,"<"&D2+"1:00")

 

[Aladin Akyurek]

Try something like

=SUMPRODUCT(B2:B200,--(HOUR(A2:A200)=x))

where x is a desired hour expressed as a whole number like 3.