Forum Discussion
A formula
Wyn Hopkinsyes it help greatly. for example pf my next question I have a sheet that December 2019 on and now January is coming so my next sheet marked Jan I would like it to say January 2020. This I would like to go on for the next five years. December 2020 would go January 2021 etc.
wjallen14 is it possible to upload a copy of the actual spreadsheet?
Do you actually need SUBTOTAL? From what you've written, it sounds like you might do just fine with SUM(A1:A10) (or whatever the column references are)....
And I assume you don't mean you literally put in =SUBTOTAL(109,[projected cost]) for each column.
Come to think of it, if this is a formal formatted Excel Table (capital "T"), I've read just recently in another posting here that SUBTOTAL isn't allowed in Tables. THAT may be the problem.