Variable totalling

[Sena]

Hi,

A table having months as columns and products in rows. I need to get the
cumulative total for the month specified. For example if I give month as 2,
it should add the first two columns and if I give months as 6 it should add
the first six columns.

I tried using offset, but it didn't work properly.

Thanks for help.

 

[Bob Phillips]

Assuming the number is in A7, and we start at column 2, here is an example

=SUM(INDEX(2:2,,2):INDEX(2:2,,1+A7))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)