Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic summary table
Hi,
I have a table with project names in column A, Resource names in column B, and the amount of time each resource will spend on the project in Jan, Feb, March etc in columns C, D, E etc. On another sheet, I want a summary table, which will have the totals for each month for each project. So in the summary, Column A will have 1 row for each project, and Column B will show total for Jan etc. The problem I have is, how do I make this dynamic? I.e. the number of project will change, as will the number of resources on each project. Thanks for any help anyone can give Barbara |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic summary table
In the summary resource names appear redundant so assuming [a] project name
in your "Detail" sheet is in every row in column A then your "Summary" sheet you could use SUMPRODUCT For January in column B2 of "Summary" =SUMPRODUCT(--(Detail!$A$2:$A$200=Summary!$A2),(Detail!C$2:C$200 )) where Summary A2 has the project name Copy across and down HTH "confused" wrote: Hi, I have a table with project names in column A, Resource names in column B, and the amount of time each resource will spend on the project in Jan, Feb, March etc in columns C, D, E etc. On another sheet, I want a summary table, which will have the totals for each month for each project. So in the summary, Column A will have 1 row for each project, and Column B will show total for Jan etc. The problem I have is, how do I make this dynamic? I.e. the number of project will change, as will the number of resources on each project. Thanks for any help anyone can give Barbara |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Table | Excel Discussion (Misc queries) | |||
Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
Dynamic Table Should Always Maintain Borders When Data Is Updated | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |