Highlighted

Calculating cells

Avatar

Avatar

_Tim_Henderson_

Avatar

_Tim_Henderson_

_Tim_Henderson_

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

Highlighted

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
Highlighted

Avatar

Avatar

_Tim_Henderson_

Avatar

_Tim_Henderson_

_Tim_Henderson_

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.
Highlighted

Avatar

Avatar

pguerett

Total Posts

7.7K

Likes

611

Correct Answer

692

Avatar

pguerett

Total Posts

7.7K

Likes

611

Correct Answer

692
pguerett

18-08-2008

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

Avatar

Avatar

_Tim_Henderson_

Avatar

_Tim_Henderson_

_Tim_Henderson_

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.