Multiple Data range
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
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!