A lookup with a SUM function?

richblake74

Active Member
Joined
Dec 30, 2006
Messages
284
Office Version
  1. 365
Platform
  1. MacOS
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
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Hi

Try this:
Code:
=SUMIFS(Log!$B$1:$B$4,Log!$A$1:$A$4,A20)
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top