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...
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...