If you have a column of data in the form:

1&2

meaning one foot, two inches, then use Data Text to Columns.. feature to
separate the data into a column for feet and a column for inches.

Once you have summed th columns, you can either convert the inches to feet
or feet to inches and add them up.
--
Gary's Student


"calimari" wrote:


Is it possible to get the sum of cells using numbers entered in feet? In
other words...I need to calculate a sum using numbers with the ' & "
symbol next to the number indicating feet & inches.

Is there a special way to do this, or do I need to convert the data to
whole numbers?

Thank you in advance. :)


--
calimari


------------------------------------------------------------------------
calimari's Profile: http://www.excelforum.com/member.php...o&userid=24537
View this thread: http://www.excelforum.com/showthread...hreadid=390229