![]() |
|
#4
|
||||
|
||||
|
If you use 3D references to sum the same range in multiple consecutive sheets you an use following trick
create a sheet called "Start", leave it blank and place it before all the sheets containing data create a sheet called "end", leave blank, place after all sheets containing data Now build your formula with the shift key from "start" to "end" Whenever a new month is added place the new sheet between "start" and "end". That's it
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Formula that looks at more than one criteria and then adds up those that match
|
DazzyBee | Excel | 2 | 01-20-2017 11:29 PM |
| Cell Ref does not automatically change when formula is copied because of data orientation | Kristinmc | Excel | 4 | 08-01-2016 10:57 AM |
| formula to send data to 2nd sheet | Normie | Excel | 5 | 01-20-2016 08:37 AM |
formula lost when copied between files
|
sandsoppa | Excel | 2 | 02-14-2012 10:38 AM |
| Formula not getting copied to entire column | theacegary | Excel | 1 | 11-29-2010 02:18 PM |