Help with the SUM formula

[exflyer1996]

I want to compare year to date data against a budget and against prior years. How do I set my sum formula up so that I can easily update the second variable?

EXAMPLE

If during the year I want to sum cells B3:M3, how do I set the sum formula up so that it starts at B3 and "runs" a certain number of columns.

Any ideas? I was thinking I could do it with the index or indirect formula or something.

 

[Jonmo1]

You can try the Offset function.

=SUM(OFFSET(B3,0,0,5,1))

The 5 will represent the total number of columns to sum (including B)

 

[exflyer1996]

Thanks, but that didn't work when I used it. It only returned the first month, not the first 5.

 

[Jonmo1]

ooops, I reversed the 1 and 5..
That should be
=SUM(OFFSET(B3,0,0,1,5))