Thread: Sum Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nenagh Nenagh is offline
external usenet poster
 
Posts: 18
Default Sum Function

Hi,

I have a spreadsheet invoice were most of the line charges are formulas
looking up other spreadsheets.

There is a sum function for the total of the column, however when it adds:

$326.08 and $32.61 the total given is $358.61. It should be $385.69.

All the cells that are being added have been formated to 2 decinal places.

How do i get the correct answer?
--
Nenagh