Originally Posted by Claus Busch

Hi,

Am Mon, 10 Sep 2012 03:16:34 +0000 schrieb VinB:

I am stuck with this dilemma please help I need to sum cells a row with
a variable range that is dependent of a number a user of the work sheet
types.

Cell A1: __ User Defined Variable {1,2,3 ect.)

Column A B C D E F
Row2 5 7 8 5 3 2 Sum A2:C2 if User defined Variable is 3
Row3 4 1 7 5 9 6 Sum A3:E3 if User defined Variable is 4
Row4 1 5 7 8 5 7 Sum A4:B4 if User defined Variable is 2

try:
=SUM(OFFSET($A2,,,,$A$1))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2