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 Removed)HIS


"Mr_Philby_Takeshi" <(E-Mail Removed)> wrote in
message news:9B527BB1-6142-4FB3-80FC-(E-Mail Removed)...
> 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.

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

--
AP

"Mr_Philby_Takeshi" <(E-Mail Removed)> a écrit
dans le message de news:
9B527BB1-6142-4FB3-80FC-(E-Mail Removed)...
> 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.

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)

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Mr_Philby_Takeshi" <(E-Mail Removed)> wrote in
message news:9B527BB1-6142-4FB3-80FC-(E-Mail Removed)...
> 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.

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)

"Mr_Philby_Takeshi" <(E-Mail Removed)> wrote in
message news:9B527BB1-6142-4FB3-80FC-(E-Mail Removed)...
> 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.