Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible.
Answers
-
I do have one last question. Lets say that I want to select the paid date for just 2023 how do I add this to this formula? I do have a Paid Date column on the sheet as well.
-
Phew 😌
🥳
Can you mark the comment from 11:59AM as the answer. Everything after that was just understanding some features specific to your sheet. Anyone with a similar problem should find the answer they need in that comment.
You enjoy your day, you did it! 💃
-
For your follow up.
- You have a formula that is summing the deal value where Inspection Type is a certain value, Contract Stage is one of two values. This is good.
- You want to do something with Paid Date in 2023.
Is Paid Date a date column?
Do you still want to sum the deal value?
If so, you can add an additional range and criteria to your SUMIFS.
First you need a formula to find the year from your Paid Date.
Then you put this into the SUMIFS (after an extra comma).
Like this:
=SUMIFS([Deal Value]:[Deal Value], [Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], OR(@cell = "7. Paid", @cell = "8. Commissioned"), [Paid Date]:[Paid Date], YEAR(@cell) = "2023")
-
This is a HUGE help! Thank you so much for your assistance.
-
Happy to help @LuminaVPSales
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!