Multiple Data range

Options

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))

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!