Highlighted

Calculating cells

_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

Guest

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

_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

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