Summing colum content

[mcglloyd]

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

 

[Rod Gill]

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

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

 

[Jim Aksel]

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