Adding numbers in rows results in zero. help!

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

 

[Nick Hodge]

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)

 

[Ardus Petus]

What are your =SUM() formula's parameters?

 

[Don Guillett]

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)

 

[Bob Phillips]

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)