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
_______________________________________________
You are currently subscribed to Framers as [EMAIL PROTECTED]
Send list messages to [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
or visit
http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com
Send administrative questions to [EMAIL PROTECTED] Visit
http://www.frameusers.com/ for more resources and info.
