Justmeok
New Member
Hi everyone
I have a colleague's spreadsheet that I cannot change the structure of but I need a formula to handle a sum function. The formula needs to update automatically rather than having to be adjusted manually each time.
I am looking for a formula that will sum a rolling 12 month period based on the individual store names (in rows) and monthly columns BUT also in separate ranges. I have added a helper row with a formula in the attached example as I was trying to write a SUMIFS formula but have discovered that won't work as the ranges are not equal. (although I could be totally incorrect here as well!!) I am really out of my depth here so would appreciate any help I can get. Please note that the solution must be a formula as it's part of a much larger report.
I have attached a simple example of what I am looking for
Thanks everyone
I have a colleague's spreadsheet that I cannot change the structure of but I need a formula to handle a sum function. The formula needs to update automatically rather than having to be adjusted manually each time.
I am looking for a formula that will sum a rolling 12 month period based on the individual store names (in rows) and monthly columns BUT also in separate ranges. I have added a helper row with a formula in the attached example as I was trying to write a SUMIFS formula but have discovered that won't work as the ranges are not equal. (although I could be totally incorrect here as well!!) I am really out of my depth here so would appreciate any help I can get. Please note that the solution must be a formula as it's part of a much larger report.
I have attached a simple example of what I am looking for
Thanks everyone
Attachments

12.3 KB Views: 8