SUMIF(S) - Referencing a Range within a Range?
I'm hoping that someone could look at this and provide a fresh take on it - my goal - is not to define 50+ ranges (representing individual columns)!
Use case: A sheet that tracks leave for individuals where columns are defined by week, as a user enters leave, the amount of time appears in the relevant column.
I would like to summarize by individual on another sheet (having the summary within the main sheet would be ideal, but, the range within the summary formula is not increasing dynamically when a new record is being added via a form).
Help Article Resources
Check out the Formula Handbook template!