Re: Title of column or row in Excel
|
Brian, ? If I want to create an Excel formula to sum amounts in rows above it and to automatically adjust to include any inserted rows, I include a blank line between the row amounts being summed and the row containing the formula and include this blank row in the sum total. For example, if my spreadsheet contains headings in row 1, current data in rows 2 through 20, and the value to be summed in column E, I'd leave row 21 blank and place this formula in cell E22: ? =Sum(E1..E21) ? Any rows inserted beginning at blank row 21 will cause the formula in cell E22 to automatically adjust to include their values in the sum. This will also be the case if new rows are inserted at the top of the sheet beginning in row 2. ? Alan Lemly ?
toggle quoted message
Show quoted text
From: [email protected] [mailto:[email protected]] On Behalf Of Brian Vogel
Sent: Wednesday, September 30, 2020 10:16 AM
To: [email protected]
Subject: Re: [office-accessibility] Title of column or row in Excel ? I do not believe you can make two heading rows for a single table.? The text in a single row (or cell in a row) can span multiple lines, though, the cell just expands vertically to accommodate it.
You can place a sum formula anywhere you wish, for any data you wish.? If you intend to have a total row you could place that, say, 20 cells below the first data row, if your table rows will be fewer than that.? I still have never figured out how to have an "auto expanding sum" where, if I add additional rows above it, the row letters beyond those that I initially set up for the sum would be included, and I don't even know if this is possible.? ? I think that they're trying to say that it's common for total rows to appear in the same column, in some row somewhere below the heading and the intervening table rows being summed.
-- Brian?-?Windows 10 Pro, 64-Bit, Version 2004, Build 19041?? It¡¯s hard waking up and realizing it¡¯s not always black and white. ?????~ Kelley Boorn
|
