subtracting a range from another range and getting a range result

C

cartoper

I have two ranges of XYZ coordinates. One is named R1 and the other
R2. Is there any way in Excell 2002 to bascially say R2-R1=R3 so that
R3 is a range the same size as R1 and R2, where each cell in R3 is is
subtraction of the corrisponding cells in R1 and R2? Sort of like
this:

r1= 3,4,5
r2=3,4,5
r3=6,8,10

of course I need to do this on a two dimentional range, there are
multiple XYZ points.
 
B

Bernard Liengme

Are the three values of R1 (3,4,5) in separate cells?
Are you adding or subtracting?
Please spell out the problem in more detail
 
C

cartoper

Are the three values of R1 (3,4,5) in separate cells?
Are you adding or subtracting?
Please spell out the problem in more detail
Click to expand...

Ok, let me try again:

A | B | C | D | E | F | G | H | J | K | L
1| 3 4 5 2 3 4 5 7 9
2| 4 5 3 4 2 3 8 7 6

RANGE1 = (A1:C3)
RANGE2 = (E1:G3)

is there any wan in Excel to say RANGE1 + RANGE2 and get a RANGE3 in
(J1:L2)?
 
Top