Sumifs from Source Page

Andrea Westrich

Hello,

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?

Genevieve P.

Hi @Andrea Westrich

Try adding two separate cross sheet SUMIF formulas together with a + symbol, like this:

=SUMIF({Week Column}, [Cell Reference]$6 - 1, {Contracts Column}) + SUMIF({Week Column}, [Cell Reference]$6 - 1, {Reservations Column})

When you're writing this out, click on the cell that currently has 44 to populate the correct column name and row reference. Then lock the formula to that row with the $ sign, like I have in my example:

[Cell Reference]$6

Then you - 1 to have one week earlier.

Let me know if this makes sense or if I can clarify anything further!

Cheers,

Genevieve

Genevieve P.

Hi @Andrea Westrich

Try adding two separate cross sheet SUMIF formulas together with a + symbol, like this:

=SUMIF({Week Column}, [Cell Reference]$6 - 1, {Contracts Column}) + SUMIF({Week Column}, [Cell Reference]$6 - 1, {Reservations Column})

When you're writing this out, click on the cell that currently has 44 to populate the correct column name and row reference. Then lock the formula to that row with the $ sign, like I have in my example:

[Cell Reference]$6

Then you - 1 to have one week earlier.

Let me know if this makes sense or if I can clarify anything further!

Cheers,

Genevieve

Andrea Westrich

Thank you@Genevieve P., worked beautifully as always!!

Genevieve P.

Wonderful! Thanks for letting me know. 🙂