Mahmoud Metwally wrote:
Dear
I want to make referene from from sheet to another in non-contigous cells
( like.A11, A21,A31,A41,....)
When I drage the cell, it just refrence contigous cells ( like
A11,A12,A13,....)
So, what is the function that I use to do that?


Hold down the Ctrl key and select each the noncontiguous cells; click on
the Name Box in the upper right portion of your sheet; insert a name
(e.g., noncontig) and hit the Enter key. You can then enter something
like, e.g.,

=SUM(noncontig) to get the sum of the values in the noncontiguous cells.

Alan Beban

Alan Beban wrote:
Mahmoud Metwally wrote:

Dear
I want to make referene from from sheet to another in non-contigous cells
( like.A11, A21,A31,A41,....)
When I drage the cell, it just refrence contigous cells ( like
A11,A12,A13,....)
So, what is the function that I use to do that?


Hold down the Ctrl key and select each the noncontiguous cells; click on
the Name Box in the upper right portion of your sheet; insert a name
(e.g., noncontig) and hit the Enter key. You can then enter something
like, e.g.,

=SUM(noncontig) to get the sum of the values in the noncontiguous cells.

Alan Beban
Oops! The Name Box is in the upper left.

Sorry,
Alan Beban