AnsweredAssumed Answered

Totals in a weldment cut list

Question asked by Hubert Carle on May 7, 2014

I added a column into the weldment cut list I call totals.  Each cell is the product of Qty and Length.  No problems. qty (3) * length (5 1/8) = 15 3/8  OR  3 * 5.125 = 15.375

 

I now want a total of all of one type so I use =sum() and have come up with some strange numbers.

   

     If the units is decimal 5.125 + 5.125 + 5.125=15.375

 

     If the units is fraction 16 (round to nearest) 5 1/8 + 5 1/8 + 5 1/8 = 15!  only the int is figured in the equasion

 

     Just for fun I also did =E2+23+E4 and got the same results. 

 

See the pictures.

 

Anyone have a clue??

CHART 1.JPGCHART 2.JPG

Outcomes