Sum by lookups

carlidee

New Member
Joined
Sep 15, 2020
Messages
7
Office Version
  1. 2016
Platform
  1. Windows
Hi there,

Can someone please help me achieve the result in the "summary table" output below?


Data source: shows the numbers of hours coded to various case codes
Case ABC​
Case DEF​
Case GHI​
Case JKL​
John400010
Kate010450
Tom200040


Summary table (desired result): adds up all hours a person worked in their row and that total is placed under each case code that they submitted hours

Case ABC​
Case DEF​
Case GHI​
Case JKL​
John500050
Kate055550
Tom600060
 

Attachments

  • 1605032456566.png
    1605032456566.png
    81.3 KB · Views: 1

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,393
Office Version
  1. 365
Platform
  1. Windows
Here is one way.

Let's say that your data above is in range A1:E4. Then you can do your SUMMARY totals in columns F:I, right next to the existing data by typing this formula in cell F2 and copying all the way to I4:
Excel Formula:
=IF(B2>0,SUM($B2:$E2),0)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,294
Messages
5,571,383
Members
412,385
Latest member
OChambo94
Top