Thread
:
Formula autofill to cells below – formula arguments are cell areas in different columns
View Single Post
#
2
Posted to microsoft.public.excel.misc
Claus Busch
external usenet poster
Posts: 3,872
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 With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch