# Sum of Variable Cells in a fixed Row

V

#### VinB

a variable range that is dependent of a number a user of the work shee
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

Tk

L

#### lhkittle

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

Tks

Hi VinB

In K1,2,3 enter 3,4,2.
In L1,2,3 enter =A2+C2, =A3+E3, =A4+B4
In J1 enter =VLOOKUP(A1,K1:L3,2,0)
In A1 enter the User defined variable.

HTH
Regard,
Howard

C

#### Claus Busch

Hi,

Am Mon, 10 Sep 2012 03:16:34 +0000 schrieb VinB:
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

V

#### VinB

Claus said:
Hi,

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

-

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

Regards
Claus Busch

Hey Claus,

Many thanks it works

Brgds
Vi