Sum by lookups

[carlidee]

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​
John	40	0	0	10
Kate	0	10	45	0
Tom	20	0	0	40

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​
John	50	0	0	50
Kate	0	55	55	0
Tom	60	0	0	60

 

[Joe4]

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:

=IF(B2>0,SUM($B2:$E2),0)