Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need a table that shows me the project#, project name and the total spent
by each team (t1,t2,..). I add the project# and proj name and team to the row field. Then I added the time to data area, but when I add time2, it only gives me the count it does not add up time1 and time2. Help!!! project # proj name Team memb time memb time 1 AAA t1 john 1 1 AAA t2 mary 3 kate 2 2 BBB t1 chris 2 2 BBB t2 kate 5 2 BBB t3 lisa 1 3 CCC t1 john 3 bob 4 4 DDD t1 bob 5 4 DDD t2 mary 2 4 DDD t3 dana 3 lisa 3 4 DDD t4 mike 2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Worksheet Functions | |||
Pivot Table Question | Excel Worksheet Functions | |||
Pivot Table Question | Excel Discussion (Misc queries) |