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
