Rick, The $ in a formula fixes a location. So, if you want to always use the same column but allow dynamic relative reassignment of the row, you'd refer to cell B3 as $B3. Likewise, if you want the column to be relative and the row fixed, it would be B$3; and if you want both column and row identifiers fixed, it would be $B$3. HTH Rene
Diane Gaskill <[EMAIL PROTECTED]> wrote: Hi Rick, I don't think there is. However, if what you are trying to do is enter that formula in several cells, you don't need it. If you move or copy that formula into another cell, it will automaticlly update to the new row and/or column number of the new cell. And you can copy it to several cells at a time. Copy the first cell, then hightlight the cells you want the formula in and paste. Make sure you are copying the cell, though, not the text in it. HTH Diane ======================= -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rick Quatro Sent: Saturday, May 12, 2007 7:10 PM To: [email protected] Cc: [EMAIL PROTECTED] Subject: OT: Excel Question 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/dgcaller%40earthlink.net Send administrative questions to [EMAIL PROTECTED] Visit http://www.frameusers.com/ for more resources and info. _______________________________________________ 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/rinnie1%40yahoo.com Send administrative questions to [EMAIL PROTECTED] Visit http://www.frameusers.com/ for more resources and info. Rene L. Stephenson eNovative Solutions, Inc. Business Phone: 678-513-0051 Email: [EMAIL PROTECTED] _______________________________________________ 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.
