Calculating cells

[_Tim_Henderson_]

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

[#2]

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

[_Tim_Henderson_]

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.

[pguerett]

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

[_Tim_Henderson_]

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.

[#6]

glad it worked out for you! 🙂