A lookup with a SUM function?

[richblake74]

Hi all.
A col has Dates in them this sheet is called "Log"

Col A Col B Col C
Wed, 19 Jun 19 5:30 6:40
Fri, 21 Jun 19 1:49 1:23
Fri, 21 Jun 19 1:11
Fri, 21 Jun 19 1:33 3:12



I have another sheet that has dates for JUNE sheet name "Monthly".
On the row that has Date on the Monthly sheet I would like it to insert and merge the same date on different rows totaling them.

A20 on Monthly Sheet has the date of "Wed, 19 Jun 19" I want it to grab the col b from the Log sheet and insert inCol B onto col B on the Log sheet on same row that Wed 19 june is on.

Then A22 on Monthly sheet has the date of 21 June I want that row and col be to total all in COL b on log sheet and insert '4:33" in B22 on.

I wish I could do a screen shot an show it more clearly but I know someone might understand my weak explanation.
Cheers

 

[shift-del]

Hi

Try this:

=SUMIFS(Log!$B$1:$B$4,Log!$A$1:$A$4,A20)