YaSso wrote:
i want to make separated cells for pounds and pisters and sum the total of
them.If pisters more than or equal 100 pisters, the integers automatically
add to the sum of pounds.


If your Pounds are in Column A and pisters (I am not familiar with that
currency) in Column B
use the following formula:

=(SUM(A1:A6))+(SUM(B1:B6)/100)

This will give pounds.pisters

edvwvw

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200805/1