I'm not clear on what you want. You want a total of the first 4 in the
first row (row 2?), first 2 in row 3? How many rows are you summing?

Barb Reinhardt



"Russell Hill" wrote:

Hi and thanks in advance for any help provided. I am trying to simplify a
nested if statement formula that sums columns of data based on the number in
another column. Here is an example:

Weeks to Sum Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7 Wk8
4 100 150 160 170 180 200
200 200
2 50 60 70 70 70 65
60 60
etc...

In the first line, I need to sume the first 4 values for a total of 580, in
the second line I need the sum of the first 2 for a total of 110. It seems
like there must be a simple formula to do this but my search has come up
empty.

Thx

Russell