Adding Numbers

[Guest]

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

 

[Guest]

Hi,

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

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

Regards,
B. R. Ramachandran

 

[rhhince]

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.

 

[MartinW]

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 D1315 and D1819
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