What's wrong with my doing the following......

  • Thread starter Thread starter L. T. Portella
  • Start date Start date
L

L. T. Portella

1. Have created a range from a1 to j1 and have named it Myrange
2. in cell a2 have typed in +Myrange and I only get the value of cell a1 and
not the entire Myrange

Can anyone help me on a step by step basis
thank you
 
L. T. Portella,

From reading your message, I ~think~ you were hoping for the same of my
range to appear in A2?

If so, "=sum(Myrange)" would work (without the quotes).

Regards,
Kevin
 
Not sure what you want to do, but when you reference a range in this way,
you get the corresponding value (to see what I mean, if MyRange is A1:A100,
put =MyRange in E5, you should get the value in A5)

If you want to sum them, use
=SUM(MyRange)

If you want to reference a specifice cell, use OFFSET
=OFFSET(MyRange,row_Offset,col_offset)


What exactly do you want to do?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
The plus sign only works with individual cells:

+A1+B1...

To add a range, you need to encase the named range in the SUM function:

=SUM(Myrange)
 
L.T.
I think what you want is for the values in the range MyRange to appear
in the A2:J2 range. Do this:
Select the range A2:J2 with A2 as the active cell. Type =MyRange and hit
Ctrl-Shift-Enter (hold Ctrl and Shift down and hit Enter). HTH Otto
 
Back
Top