Hello,
I am trying to sum up a column with a heading "Total Charges" on one sheet (always the 9th sheet, but deleted every month) and input the value into cell B8 on another sheet. The sum will be displayed will always be called "Summary."
I am at a loss on how to write the sum formula that will display the value on "Summary" without explicitly referencing the sheet name with the source data.
Thank you for any help you can provide!
Bookmarks