Need help with OFFSET statement

[Steelhead]

Is there a way to make the last two parts ("height" and "width") of the OFFSET statement formula static (meaning they alway refer to the same cell)? I am inputting a different number in the "colum" section of the formula and every time I do...it changes which cells the "height" and "width" refer to.
Please help!
Matt

[NBVC]

To always refer to the same cells make the cell reference absolute by adding $ signs before both the column and row references...

e.g. $C$5

[Steelhead]

Thanks NBVC but...
I tried that but it doesn't work using a '$" in the last part ("height" and "width") of a OFFSET statement. The "$" does work in the "column" portion of the formula.

[NBVC]

Are you trying to enter a reference to a cell that contains numbers (for height,width) or are you hard coding the numbers?

Can you show your formula and what is going wrong?

[Steelhead]

Yes...I'm trying to enter a reference to a cell that contains numbers (for height,width)
I've attached an example of what I'm trying to do. If there is an easier way instead of using the OFFSET" function...I'm all for it. The formula is in cell P7. I'm trying to add up a set of number after the user inputs a starting month/number. So...if the user inputs a 4 (in cell B2)...the formula will add all values from April to December. If the user inputs a 6 (in cell B2)...the formula will add all values from June to December....and so on. See attached test worksheet.
Thanks (in advanced) for your help everyone!!!

[NBVC]

You can use: =SUM(OFFSET(C7,0,B2-1):N7)

or better yet: =SUM(INDEX(C7:N7,B2):N7)

[Steelhead]

Many thanks NBVC....you are the man!