Sort out working hours for workers based on company / project

**HammerStein** · 09-05-2012, 10:52 AM

Dear gurus,

I have a sheet that consist of customers, different projects and peoples assigned to the different projects (see the example below). I would like to sort the assigned workers and make a summary of the estimated hours for each assigned worker. I've tried various methods but I cant really get Excel to munch through the list of companies and grab the various users. Any tips on how to solve this headache of mine is appreciated.

Klient

Klientnr

Revisor

Worker

Tid för

Funktion

Räk.år

Okt

Nov

Dec

Jan

Feb

Mar

Apr

Maj

Jun

Jul

Aug

Sep

Summary

Company 1

10025

CE

JJ

DC

M

1231

10

Company 3

10058

CE

JJ

DC

M

1231

5

Company 3

10058

CE

JJ

DC

M

1231

5

Company 1

10025

CE

AW

DC

M

1231

10

Company 2

10060

CE

KR

DC

M

1231

9

18

Company 3

10058

CE

JJ

DC

M

1231

5

Company 1

10025

CE

JJ

DC

M

1231

3

14

20

Company 2

10060

CE

KR

DC

M

1231

5

9

14

Company 3

10058

CE

AW

DC

M

1231

5

Desired result:

Klient

Klientnr

Revisor

Worker

Tid för

Funktion

Räk.år

Okt

Nov

Dec

Jan

Feb

Mar

Apr

Maj

Jun

Jul

Aug

Sep

Summary

Company 1

10025

CE

JJ

DC

M

1231

10

Company 1

10025

CE

JJ

DC

M

1231

3

14

20

Company 3

10058

CE

JJ

DC

M

1231

5

Company 3

10058

CE

JJ

DC

M

1231

5

Company 3

10058

CE

JJ

DC

M

1231

5

Summary

45

Company 2

10060

CE

KR

DC

M

1231

9

18

Company 2

10060

CE

KR

DC

M

1231

5

9

14

Summary

32

Company 1

10025

CE

AW

DC

M

1231

10

Company 3

10058

CE

AW

DC

M

1231

5

Summary

15

Or something like this:

	JJ	KR	AW
Company 1	30	0	10
Company 2	0	32	0
Company 3	15	0	5

**HammerStein** · 09-05-2012, 11:01 AM

Absolutely, thanks for reminding me.

**HammerStein** · 09-07-2012, 10:37 AM

Bump... I don't really know how to solve this problem on my own. Any help is much appreciated.

**Cutter** · 09-07-2012, 08:00 PM

To get the small table shown in your first post:

With your original table in range A1:T10

Your small summary table would be in range A14:D17

Place this formula in cell B15: =SUMIFS($T$2:$T$10,$A$2:$A$10,$A15,$D$2:$D$10,B$14)

drag over and down

**HammerStein** · 09-17-2012, 08:19 AM

Thanks for the help. Much appreciated!

**Cutter** · 09-18-2012, 10:21 AM

You're welcome. And welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.