Designate # of columns to sum

[m24jones]

Is there a way I could designate the number of columns to sum? So If I put a 4 in a cell then my formula below would grab A3 and the 3 columns to the right?

For example, on one tab I have a basic set of data by month:

Column: A B C
Month: Jan Feb Mar
Data: 51 34 96

On a different tab I would like to sum the data, but use a # to designate the number of columns to sum including January instead of changing the formula manually.

Thanks in advance for any help...

 

[njimack]

=SUM(OFFSET(A3,0,0,,4))
(the 4 could be linked to a particular cell, rather than within the formula)

 

[VoG]

Maybe like this with column letter rather than number

Excel Workbook
	A	B	C	D
1	Jan	Feb	Mar	B
2	51	34	96	85
Sheet2

 

[T. Valko]

Is there a way I could designate the number of columns to sum? So If I put a 4 in a cell then my formula below would grab A3 and the 3 columns to the right?

For example, on one tab I have a basic set of data by month:

Column: A B C
Month: Jan Feb Mar
Data: 51 34 96

On a different tab I would like to sum the data, but use a # to designate the number of columns to sum including January instead of changing the formula manually.

Thanks in advance for any help...

One way...

=SUM(A3:INDEX(A3:Z3,A1))

Where A1 = the number of coulmns to be summed.

Note that if A1 is an empty cell the formula will calculate the entire range.