Adding numbers in rows results in zero. help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

I have created a summary sheet for my personal budget summarising totals for
the financial year. I am trying to add a row of cells B24 to E24 which have
the values $11.60, $0.40, $15.00 and $15.50 using the SUM function. I know it
equals $42.50 because it displays this total in the status bar when cells
B24:E24 are highlighted. However, the function returns a result of $0.00 in
cell F24. The cells are formatted as currency. I have tried embedding VALUE()
into the sum function as suggested by another user on this discussion board
with no success. Any ideas of possible solutions?

cheers Phil.
 
I'm not sure that putting VALUE around a sum function will bump 'text
numbers' into actual numbers

Try entering a 1 in a spare cell and copy it.

Highlight B24:E24 and then Edit>Paste Special...>Values+Multiply. This
should fix the numbers

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
You probably have the values entered
'$ 11.60 when it needs to be
11.60 and then format as currency
try this:
put 1 in a cell somewhere>copy that cell>highlight all cells with your text
values>edit>paste special>multiply.
your formula should be
=sum(b24:e24)
 
This doesn't sound right. If they were text, the SUM in the status bar would
not show properly. IS there anything unusual with your SUM function?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top