Formula autofill to cells below – formula arguments are cell areas in different columns

P

pv854624

Hello,

I have a sheet that contains a sum function in cell B1 and I would like to autofill B2:B6. However, the addends of the sums for each of these cells are in different columns, namely, in cells E2:E4, F2:F4, G2:G4 etc. How do I accomplish this? Using absolute references for rows, columns, or both doesn't work.

This picture should illustrate the problem:
http://www3.picturepush.com/photo/a/9300441/img/9300441.gif


Pekka
 
C

Claus Busch

hi Pekka,

Am Fri, 7 Sep 2012 13:02:37 -0700 (PDT) schrieb (e-mail address removed):
I have a sheet that contains a sum function in cell B1 and I would like to autofill B2:B6. However, the addends of the sums for each of these cells are in different columns, namely, in cells E2:E4, F2:F4, G2:G4 etc. How do I accomplish this? Using absolute references for rows, columns, or both doesn't work.

This picture should illustrate the problem:
http://www3.picturepush.com/photo/a/9300441/img/9300441.gif
Click to expand...

try:
=SUM(OFFSET($E$2,,ROW(B1)-1,3))


Regards
Claus Busch
 

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

Reference to One Cell stays the same in Different Formula 10
range label works in VLOOKUP except if refenced in another cell 3
MAx formula - Tedious process of writing all arguments individually 3
help needed to compile a macro (replace only 8 cells of a row fromnext raw if one cell has value of 1
Populate formula results in cells to next unique result. VBA or Fu 1
seperating text in one cell to multiple cells 13
VBA code to Autofill one cell to many rows below where row count will change 5
Move data from different columns into one column, but different rows. 2

Top