Sumifs from Source Page
I have a source sheet where data is input daily. It collects among other things the number of reservations and contracts for each day. As you can see it has a date, reporting column (where the distinctions are made), Reservations column, a contracts column, and a Week # helper column.
Below is my Summary Sheet. It has where I want to sum the total # of Contracts + Reservations if the Week column in the source sheet is 1 less than the cell below that has the Current Week (see 44 below).
How can I write that formula?
Help Article Resources
Check out the Formula Handbook template!