The sum is always 0!

  • Thread starter Thread starter karina
  • Start date Start date
K

karina

Hi.
I have have a list of product values (all numbers) and at
the bottom of the same page I want a box with the sum of
all these products added together, when I put a formula
together it gives me the right result in the creations
box, but when ok is selected the result that actually
appears in the table is 0 can anyone please help!!!!!!!
 
Hi Karina
one idea: Your values are probably formated as text. Try the following
- select you column
- goto 'Format -Cells' and change the format to 'Number'
- put the value 1 in a single/empty cell
- copy this cell (with CTRL+C)
- select your column with your product values
- goto 'Edit - Paste Special' and choose multiply

this procedure should change all entries in your column to numbers.
check the sum formula again
 
Back
Top