Formula Help?

[starky5]

Here is an exampl of my data on a spreadsheet related to tracking the hours of team members for each project we are working on:

Jan Feb Mar Apr Total
Project A
John - Primary 5 10 20 5 40
Joe - Secondary 5 5 10 5 25

Project B
Joe Primary 5 30 20 5 60
Sue Secondary 5 5 5 5 20

Project C
Bill Primary 20 20 30 10 80
John Seecondary 5 10 20 5 40

What I want to do on another sheet is create a summary table that would have data like this:

John Primary hours = ??
John Secondary hours = ??
Joe Primary hours = ??
Joe Secondary hours = ??
Sue Primary hours = ??
Sue Secondary hours = ??
Bill Primary hours = ??
Bill Secondary hours = ??


Basically the logic needs to lookat column A1:A20, and if it equals "John Primary", keep a running total of the hours in the last column.

Is this possible?

Thanks...

 

[Aladin Akyurek]

Here is an exampl of my data on a spreadsheet related to tracking the hours of team members for each project we are working on:

Jan Feb Mar Apr Total
Project A
John - Primary 5 10 20 5 40
Joe - Secondary 5 5 10 5 25

Project B
Joe Primary 5 30 20 5 60
Sue Secondary 5 5 5 5 20

Project C
Bill Primary 20 20 30 10 80
John Seecondary 5 10 20 5 40

What I want to do on another sheet is create a summary table that would have data like this:

John Primary hours = ??
John Secondary hours = ??
Joe Primary hours = ??
Joe Secondary hours = ??
Sue Primary hours = ??
Sue Secondary hours = ??
Bill Primary hours = ??
Bill Secondary hours = ??


Basically the logic needs to lookat column A1:A20, and if it equals "John Primary", keep a running total of the hours in the last column.

Is this possible?

Thanks...

With E2 housing a value like John Primary:

=SUMIF(Source!$A$2:$A$100,E2,Source!$G$2:$G$100)

 

[starky5]

Thank you, that did the trick.