Copying cell formulas

D

D.Robison

Excel 2003 ...
I have a cell formula for sheet 2 of an excel spreadsheet that is for row 1
"=Cu!A1+Cu!A2+Cu!B1+Cu!B2", where A1, A2, B1 & B2 are numbers from sheet 1
(renamed Cu); and
The formula for row 2 of sheet 2 needs to be "=Cu!A3+Cu!A4+Cu!B3+Cu!B4".

If I copy the formula for row 1 and paste it into row 2, the formula shows
as: "=Cu!A2+Cu!A3+Cu!B2+Cu!B3" -- which is not correct.

Short of deleting every other line (which would be rather tedious as I have
140 rows and as many columns), anybody have any suggestions for formatting
the formula. HELP ... the worksheets need completed by tomorrow.
 
R

RagDyer

Try this for A1 to B140:

=SUM(INDEX(Cu!A$1:A$140,2*ROWS($1:1)-1):INDEX(Cu!B$1:B$140,2*ROWS($1:1)))

Copy down as needed.

Revise the ranges to match your specs.
 

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

Top