Sort out working hours for workers based on company / project

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

10

Company 3

10058

CE

JJ

DC

M

1231

5

5

Company 3

10058

CE

JJ

DC

M

1231

5

5

Company 1

10025

CE

AW

DC

M

1231

10

10

Company 2

10060

CE

KR

DC

M

1231

9

9

18

Company 3

10058

CE

JJ

DC

M

1231

5

5

Company 1

10025

CE

JJ

DC

M

1231

3

3

14

20

Company 2

10060

CE

KR

DC

M

1231

5

9

14

Company 3

10058

CE

AW

DC

M

1231

5

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

10

Company 1

10025

CE

JJ

DC

M

1231

3

3

14

20

Company 3

10058

CE

JJ

DC

M

1231

5

5

Company 3

10058

CE

JJ

DC

M

1231

5

5

Company 3

10058

CE

JJ

DC

M

1231

5

5

Summary

45

Company 2

10060

CE

KR

DC

M

1231

9

9

18

Company 2

10060

CE

KR

DC

M

1231

5

9

14

Summary

32

Company 1

10025

CE

AW

DC

M

1231

10

10

Company 3

10058

CE

AW

DC

M

1231

5

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