Multiple Data range

Marilen.Navarro103391

Hello,

Hope you could help me. How can I get data for Closed AND Scheduled?

I can get "Closed" but I also wanted "Scheduled". They belong in only one Column.

My formula is below.

=SUMIFS({Rev FIle 10.12 Database Range 1}, {Rev FIle 10.12 Database Range 2}, "Tere", {Rev FIle 10.12 Database Range 3}, "Closed", "Scheduled", {Rev FIle 10.12 Database Range 4}, AND(IFERROR(MONTH(@cell), 0) = 10, IFERROR(YEAR(@cell), 0) = 2021))

Genevieve P.

Hi @Marilen.Navarro103391

You're close! Try this:

=SUMIFS({Rev FIle 10.12 Database Range 1}, {Rev FIle 10.12 Database Range 2}, "Tere", {Rev FIle 10.12 Database Range 3}, OR(@cell = "Closed", @cell = "Scheduled"), {Rev FIle 10.12 Database Range 4}, AND(IFERROR(MONTH(@cell), 0) = 10, IFERROR(YEAR(@cell), 0) = 2021))

This tells the formula to look for both options. Let me know if this works for you!

Cheers,

Genevieve

Genevieve P.

Hi @Marilen.Navarro103391

You're close! Try this:

=SUMIFS({Rev FIle 10.12 Database Range 1}, {Rev FIle 10.12 Database Range 2}, "Tere", {Rev FIle 10.12 Database Range 3}, OR(@cell = "Closed", @cell = "Scheduled"), {Rev FIle 10.12 Database Range 4}, AND(IFERROR(MONTH(@cell), 0) = 10, IFERROR(YEAR(@cell), 0) = 2021))

This tells the formula to look for both options. Let me know if this works for you!

Cheers,

Genevieve