Formula Help?

starky5

New Member
Joined
Jun 23, 2004
Messages
3
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...
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
starky5 said:
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,253
Members
412,709
Latest member
Rishu
Top