Calculating cells

Avatar

Avatar
Level 2
_Tim_Henderson_
Level 2

Likes

0 likes

Total Posts

19 posts

Correct reply

0 solutions
View profile

Avatar
Level 2
_Tim_Henderson_
Level 2

Likes

0 likes

Total Posts

19 posts

Correct reply

0 solutions
View profile
_Tim_Henderson_
Level 2

18-08-2008

I am trying to set up a cell that gives the total of a number of other cells. I know that in the object value you can choose calculated but I do not understand how to link to what cells I want to be the values. Thank you in advance for your help.



Tim Henderson

Replies

Avatar

18-08-2008

try this replaceing my names of course with those that you are trying to add up. I have 3 thigns being added together and this is the calculation needed:



Sum(RegistrationCost,EstimatedHotelCost,EstimatedTravelCost)



Good luck

Avatar

Avatar
Level 2
_Tim_Henderson_
Level 2

Likes

0 likes

Total Posts

19 posts

Correct reply

0 solutions
View profile

Avatar
Level 2
_Tim_Henderson_
Level 2

Likes

0 likes

Total Posts

19 posts

Correct reply

0 solutions
View profile
_Tim_Henderson_
Level 2

18-08-2008

Thank you for this information. I left a vital piece of information out, these cells are in column in the table. and I am trying to add top to bottom. Thanks again.

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

18-08-2008

Then using a formcalc expression you can use Sum(ColumnName[*].fieldname)

Avatar

Avatar
Level 2
_Tim_Henderson_
Level 2

Likes

0 likes

Total Posts

19 posts

Correct reply

0 solutions
View profile

Avatar
Level 2
_Tim_Henderson_
Level 2

Likes

0 likes

Total Posts

19 posts

Correct reply

0 solutions
View profile
_Tim_Henderson_
Level 2

18-08-2008

I was just coming back to say that I think I figured it out. I created my sum statement like this:

sum(ParcelOne.Acres,ParcelTwo.Acres,ParcelThree.Acres,ParcelFour.Acres,ParcelFive.Acres,ParcelSix.Acres,ParcelSeven.Acres)



And it did what I needed it to do.



Once again, thank you for your help.