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.

Assume data for Bays 1 to 3 are in cells A2,A3 and A4 then:

=SUM(A2:A4)

HTH

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

Hi

I am assuming that these weights are not decimal weights, but lbs and
ozs.
e.g. 10.12 is really 10 pounds and 12 ounces

If so, and with data in A1:A3, the following array entered formula will
produce your result

{=SUM(INT(A1:A3))+(INT(SUM(MOD(A1:A3,1)*100)/16))&"."
&ROUND(MOD(SUM(MOD(A1:A3,1)*100),16),0)}

To enter or edit an Array formula use Control+Shift+Enter (CSE) not just
Enter.
Excel will insert the curly braces { } when you use CSE. Do not type
them yourself.
--
Regards

Roger Govier


"norcalff_dm" wrote in message
...
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.

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