Set up one workbook with its only sheet being the responses. It's much better to use a second workbook. Ideally this shouldn't be done within one sheet. NOTE: We do our books manually, we are not in the position to pay someone or buy any software. Let me know if there are any other questions that would clarify anything. I just have had no luck playing with settings or searching google for an answer. I've seen this done before, in where the TOTAL box floated as the sheet was scrolled thru and was not affected by the rest of the sheet. I've already tried 'freezing' the column, but that didn 't seem to work, plus I had to move it on the left side of the sheet. (not a big issue but would be nice to fix) When scrolling, I'd like to keep the TOTAL info on the side.(The most annoying/biggest issue) When info is being auto-filled by the form, it adds a whole new row, leaving gaps in the TOTAL section.This sheet is auto-filled by being linked to a Google Form. In our expenses sheet we have our expenses listed by date/type/amount and then we have a section on the same sheet that totals it together depending on the type of expense.