i need to total weights on a worksheet

N

norcalff_dm

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

Roger Govier

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

Gord Dibben

=SUM(A1:A3)

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


Gord Dibben MS Excel MVP
 
Top