subtracting a range from another range and getting a range result

  • Thread starter Thread starter cartoper
  • Start date Start date
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.
 
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
 
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)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select range then copy rows macro 1
Selection multiple ranges with Cells property 4
Problem with repeating values in report 1
pushing data from one worksheet to another 6
Sumif with multiple sum ranges in a sheet 4
Count in a field 1
.copy problems 4
copy no match 2

Back
Top