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 |
All times are GMT +1. The time now is 05:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com