| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula autofill to cells below – formula arguments are cell areas in different columns
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/...mg/9300441.gif Pekka |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula autofill to cells below ? formula arguments are cell areas in different columns
hi Pekka,
Am Fri, 7 Sep 2012 13:02:37 -0700 (PDT) schrieb : 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/...mg/9300441.gif try: =SUM(OFFSET($E$2,,ROW(B1)-1,3)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for several arguments results in 1 cell | Excel Discussion (Misc queries) | |||
| Formula to spread one number over 2 or 3 or .....8 different areas | Excel Discussion (Misc queries) | |||
| autofill with one part of the formula refering to a constant cell | Excel Discussion (Misc queries) | |||
| formula or VBA - would like to autofill cells based on start date and # of months | Excel Programming | |||
| How do I output a formula into a cell and then autofill using vb? | Excel Programming | |||
Hybrid Mode
