OT: Excel Question

[Rick Quatro]

Hello Framers,

I am using a formula in Excel to sum the values in a row:

=SUM(B2:F2)

Is there a way to use a generic row reference in a formula? For example, I 
don't know for sure at run time if the data and formula is going to end up 
in the second row. What I want is something like this

=SUM(B#:F#)

where the # sign would indicate the current row containing the formula.

Thank you very much.

Rick Quatro
Carmen Publishing
585-659-8267
www.frameexpert.com