98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Autosum of Summary Taks
Autosum of Summary Taks
Resolved · Urgent Priority · Version 2010
Lee has attended:
Project Introduction course
Project Intermediate course
Autosum of Summary Taks
Please can you tell me how i can get a summary task to autosum information submitted in sub tasks? It seems to work for some columns and not others.
For example, if you insert the column titled 'Cost', then add values into subtasks costs, the total summary task cost gets automatically calculated in the summary task row.
However, if you then add a column titled 'Cost 1' and again add values into subtasks costs1 the summary task row stays at £0.00.
I need to add 13 'Cost' columns, 1 for a total figure, then a separate cost for each calendar month. I can only see 10 'Cost' columns (Cost1 to Cost10). Is it possible to add extra 'Cost' columns
Many thanks
Lee
RE: Autosum of Summary Taks
Hi Lee
With Project unfortunately only the Cost column automatically totals in the Summary Task, not the Fixed cost or custom fields like 1.
Here's a suggestion for displaying costs for each month and an overall total:
Insert the Cost filed then create a summary task for each month indenting the tasks below each month. To see the yearly total select Format, Project Summary Task.
Also there is a Cash Flow report that can be edited to show costs for each month.
Project, Reports, Costs,
Single click Cash Flow and choose Edit
Change interval from 1 week to 1 month
Select
I'm guessing what your project looks like for now but hope that help in some way.
Doug
Doug Dunn
Best STL
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Thu 20 Dec 2012: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Inserting Task Durations QuicklyWhen entering durations for your tasks simply use the single letters - m for min, h for hr, d for day, w for week, but mon for month. If default is set for days, you need only type the number, for example 3 for 3days, or 0.5 for half a day. |