Prev: Linking Tasks
Next: Project summary tasks - testing for links or resources
From: mcglloyd on 15 Feb 2010 15:58
I have a new field that relates to each activity.
How do I sum the numeric content of all the fields in a column?

Thanks
Mike

From: Rod Gill on 15 Feb 2010 16:42
For cost, work etc Summary Tasks automatically sum the data so I assume you
have a custom field??

If so, under Tools, Customize, Fields Select Sum for the Calculation for
Task and group summary fields.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




"mcglloyd" <mcglloyd(a)discussions.microsoft.com> wrote in message
news:4C57B227-CD01-4191-952F-FFA459804F54(a)microsoft.com...
> I have a new field that relates to each activity.
> How do I sum the numeric content of all the fields in a column?
>
> Thanks
> Mike
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4869 (20100215) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4869 (20100215) __________

The message was checked by ESET Smart Security.

http://www.eset.com



From: Jim Aksel on 15 Feb 2010 16:55
It is best if the value is contained in a custom number column (number1,
number2...) instead of a text column (text1, etc).

Use the customize feature (right click on the number1 colum and select
"Customize Fields". There are several areas on the form. One area deals
with a formula for the individual descrete tasks ... leave that blank.
Another area (immediately below) is how to deal with summary tasks.

In the section for "Calculation of group and summary rows" select the option
for Rollop and select "Sum" from the drop down.

This will work if the custom field is a number. If your custom field is
text, you will need a solution using VBA Code (a macro). Probably easier to
make sure you use a number column for your custom field.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com



"mcglloyd" wrote:

> I have a new field that relates to each activity.
> How do I sum the numeric content of all the fields in a column?
>
> Thanks
> Mike
>
 | 
Pages: 1
Prev: Linking Tasks
Next: Project summary tasks - testing for links or resources