Either of these works:
=SUM(INDIRECT("B"&ROW()):INDIRECT("F"&ROW()))
=SUM(INDEX(B:B,ROW()):INDEX(F:F,ROW()))
I got the answer on the microsoft.public.excel Usenet group. Thanks to those
on Framers that took a stab at it.
Rick
> 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
