Formula multiple IFS
Trying to write a formula that says look at the Requested screening type(s), Month approved screening, Year of event and if they are the same as on the MAIN - Dont Touch Onsite Request Form sheet then sum the Projected Volume from the MAIN - Dont Touch Onsite Request Form sheet
Getting an incorrect argument error - Help?
=SUMIFS({MAIN - Dont Touch Onsite Request Form Range 2}, [Requested screening type(s)]@row, {MAIN - Dont Touch Onsite Request Form Range 9}, [Month approved screening]@row, {MAIN - Dont Touch Onsite Request Form Range 7}, [Year of event]@row, {MAIN - Dont Touch Onsite Request Form Range 8})
Answers
-
Looks like your syntax is a little off. SUMIFS() need two ranges at the beginning. Assuming {Range 8} is the Projected Volume you are wanting to add up, I think this should work for you:
- =SUMIFS({MAIN - Dont Touch Onsite Request Form Range 8}, {MAIN - Dont Touch Onsite Request Form Range 2}, [Requested screening type(s)]@row, {MAIN - Dont Touch Onsite Request Form Range 9}, [Month approved screening]@row, {MAIN - Dont Touch Onsite Request Form Range 7}, [Year of event]@row)
I hope this helps!
Best,
Zach Hall
Training Delivery Manager / Charter Communications
-
Thank you that got rid of the error but its returning 0 when there should be numbers. Could it be that the Month approved screening and Year of event is a formula on the main sheet and not on the working sheet?
-
I don't believe that should impact the formula. I'm concerned that potentially I chose the wrong range to add at the start of the SUMIFS(). Not knowing what is in each of your ranges, it was a best guess. I would check to make sure the {Range 8} contains the values you were wanting to add up.
Best,
Zach Hall
Training Delivery Manager / Charter Communications
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives