I'm new to excel and I'm trying to add a group of different numbers... What I
did was this =sum((b10:b19)+(d13:d15)+(d18:d19))
And it tells me #value!
Help, what am I doing wrong.... Thanks for your help...

Hi,

=sum(b10:b19,d13:d15,d18:d19)

Separate the sections using commas, not the '+' signs.

Regards,
B. R. Ramachandran

"CanineSleepOver" wrote:

I'm new to excel and I'm trying to add a group of different numbers... What I
did was this =sum((b10:b19)+(d13:d15)+(d18:d19))
And it tells me #value!
Help, what am I doing wrong.... Thanks for your help...

On Nov 10, 11:24 pm, CanineSleepOver
wrote:
I'm new to excel and I'm trying to add a group of different numbers... What I
did was this =sum((b10:b19)+(d13:d15)+(d18:d19))
And it tells me #value!
Help, what am I doing wrong.... Thanks for your help...

You could try =sum(b10:b19,d13:d15,d18:d19) assuming you are adding
only numbers. That should do it.

Hi,

Another way is to select your cells and Name them as a range.

To name the range in your example,
Highlight B10:B19
Hold down Ctrl and highlight D13:D15 and D18:D19
Click in the name box at the top left of your sheet,
(it is just to the left of the Formula bar)
Type in a name say Range1 and hit enter.

Your formula now becomes =SUM(Range1)

HTH
Martin


"CanineSleepOver" wrote in
message ...
I'm new to excel and I'm trying to add a group of different numbers...
What I
did was this =sum((b10:b19)+(d13:d15)+(d18:d19))
And it tells me #value!
Help, what am I doing wrong.... Thanks for your help...