SOLVED: Re: Excel Question
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
SOLVED: Re: Excel Question
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.