Sorting a table without include the Total row
Hi,
I have a table with a row on the bottom that is the total of all the items in the spreadsheet. How do I sort the rows and columns without including the "Total" row at the bottom?
Thanks
This is pretty much the same problem being asked about in the thread Absolute or relative cell reference in source doc , though you wouldn't know it from the title. The solution for you may be a little simpler, though. Here is one possible solution:
- Insert a new column.
- In that column, put a 1 in each row that has a value you want in the sum. Leave the other cells blank.
- If your data is in column B and this new column is column C, the total formula will be =SUMIF(C,1,B)
- Hide that extra column if you don't want to see it.
Alternatively, if you regularly change which items you are totaling or if you often include new items:
- Insert a new column.
- In the header for that column put something like "Include in Total"
- Format the column as checkboxes
- Check the ones you want to include, leave the others unchecked
- The total formula will be =SUMIF(C,TRUE,B)
- Do not hide the new column