Prev: Trouble opening xlsx with 2007
Next: How do I copy and edit photos received in an excel spreadsheet
From: oldLearner57 on 5 Jul 2008 22:30
hi community

when I use the Sum() to add a range and within the range of cells there is 1
cell that has Text data
and
the output of the Sum() function does not display the #value! error
however
when I used the "=" and added up all the cells
the output display the #value! error
can someone kindly enlighten me on this?

thanks community

:)
--
oldLearner57
From: T. Valko on 5 Jul 2008 22:39
It's because the SUM function ignore text but using simple arithmetic does
not:

A1 = 10
A2 = x
A3 = 10

=SUM(A1:A3) = 20

=A1+A2+A3 = #VALUE!

=10+x+10 = #VALUE!

--
Biff
Microsoft Excel MVP


"oldLearner57" <oldLearner57(a)discussions.microsoft.com> wrote in message
news:D25D12DF-AC66-4799-A3DA-DF72571CE68B(a)microsoft.com...
> hi community
>
> when I use the Sum() to add a range and within the range of cells there is
> 1
> cell that has Text data
> and
> the output of the Sum() function does not display the #value! error
> however
> when I used the "=" and added up all the cells
> the output display the #value! error
> can someone kindly enlighten me on this?
>
> thanks community
>
> :)
> --
> oldLearner57


 | 
Pages: 1
Prev: Trouble opening xlsx with 2007
Next: How do I copy and edit photos received in an excel spreadsheet