B
BenRam
I need to do a tabulation so that two columns are added together and the
result is shown in the third column.
result is shown in the third column.
M
Mike Glen
Hi BenRam,
Welcome to this Microsoft Project newsgroup
Essentially you uses three of the free fields like Number 1,2 & 3. You
insert the data in 1 & 2 and in 3 you insert a formula like
[Number1]+[Number2]. A fuller explanation can be found in my series on
Microsoft Project in the TechTrax ezine, particularly #14 – Customizing
Fields , at this site: http://tinyurl.com/2xbhc (Perhaps you'd care to rate
it before leaving the site, Thanks.)
FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>
Hope this helps - please let us know how you get on
Mike Glen
MS Project MVP
Welcome to this Microsoft Project newsgroup
Essentially you uses three of the free fields like Number 1,2 & 3. You
insert the data in 1 & 2 and in 3 you insert a formula like
[Number1]+[Number2]. A fuller explanation can be found in my series on
Microsoft Project in the TechTrax ezine, particularly #14 – Customizing
Fields , at this site: http://tinyurl.com/2xbhc (Perhaps you'd care to rate
it before leaving the site,
Thanks.)FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>
Hope this helps - please let us know how you get on
Mike Glen
MS Project MVP
J
John
Ben,
All you need to do is set up a custom field with a formula that add the
two other fields (columns). Go to Tools/Customize/Fields and, depending
on what type of data you are using (i.e. cost, duration, number, etc.)
pick a spare field (e.g. Number1 if the columns to be added are integer
or floating point values) and hit the "formula" button on the Customize
Fields windows. Then just set up the formula you want. For example,
Number1 = [Number2] + [Number3].
Note that the formula will apply to all task rows, not just a single
task and you will need to select the appropriate roll up formula for
Summary rows on the Customize Fields window.
Hope this helps.
John
All you need to do is set up a custom field with a formula that add the
two other fields (columns). Go to Tools/Customize/Fields and, depending
on what type of data you are using (i.e. cost, duration, number, etc.)
pick a spare field (e.g. Number1 if the columns to be added are integer
or floating point values) and hit the "formula" button on the Customize
Fields windows. Then just set up the formula you want. For example,
Number1 = [Number2] + [Number3].
Note that the formula will apply to all task rows, not just a single
task and you will need to select the appropriate roll up formula for
Summary rows on the Customize Fields window.
Hope this helps.
John