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