Either of these works:



I got the answer on the microsoft.public.excel Usenet group. Thanks to those 
on Framers that took a stab at it.


> 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

Reply via email to