=SUM(A1:A3)

Assuming A1 has weight of coins from bay#1, A2 has coins from bay#2 etc.


Gord Dibben MS Excel MVP

On Mon, 19 Feb 2007 09:48:08 -0800, norcalff_dm
wrote:

i am weighing coins from a coin-op car wash and i need to sum up all the bays
of the car wash in a spreadsheet. ex: bay #1 has 10.12lbs of coin and bay#2
has 8.15lbs and bay#3 has 9.11lbs how would i do that?? thanks
im using excel 2003.