I have a very simple worksheet with financial data. It has 13 columns and formulas in 6 of them. The first row is column headings. The second row is beginning balances and should not be included in the calculations for the remainder of the column. I simply cannot figure out how to maintain the formula(s) as rows are added to the columns. I tried creating a table and using calculated columns, but the formula over-rode row 2 beginning balances.
This seems like a very ordinary need yet I can't resolve it. I am fairly new to Excel so your answers need to not assume a great knowledge base. I'm learning as I go. Thanks.
[Mod note: cross-posted here: http://www.excelguru.ca/forums/showthread.php?6803-Omitting-rows-from-a-calculated-column
Please take a moment to read the forum rules especially as regards cross-posting etiquette.]
This seems like a very ordinary need yet I can't resolve it. I am fairly new to Excel so your answers need to not assume a great knowledge base. I'm learning as I go. Thanks.
[Mod note: cross-posted here: http://www.excelguru.ca/forums/showthread.php?6803-Omitting-rows-from-a-calculated-column
Please take a moment to read the forum rules especially as regards cross-posting etiquette.]
Last edited by a moderator:
