formula question
I have a sheet that has columns of Color Status, As Sold Budget, and Status. Color Status equals either PURPLE, GREEN, YELLOW or RED. As Sold Budget is a column of dollars. Status is either At Gosiger, Close, SAT Pending, Shipped Debug, Need Final Docs, or On Hold.
Conditions of the formula...
If the Status is not equal to "Close" and the Color Status is "Purple", I want sum the As sold Budget. My Formula is as below.
=IF(AND(Status6:Status58, <>"Close", [Color Status]6:[Color Status]58, ="PURPLE", SUM([As Sold Budget]6:[As Sold Budget]58)))
The return is (Incorrect Argument)
Please advise on what I am doing wrong.
Regards,
DS
Best Answers
-
Bassam,
Your suggestion worked. Thank you for your help!
DS😀
-
I want to put the formula and copy as follows:
PURPLE 7[As Sold Budget]59 (CEll 74)
GREEN 7[As Sold Budget]59 (Cell 75)
YELLOW 7[As Sold Budget]59 (Cell 76)
RED 7[As Sold Budget]59 (Cell 77)
Then move to Current Budget, Current Est, Current Sales.
Regards,
-
Excellent 😀
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @1996mustang
Hope you are fine, please add a copy or screenshot after removing any sensitive data.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Try the following formula
=SUMIFS([As Sold Budget]6:[As Sold Budget]58, [Color Status]6:[Color Status]58, @cell = "PURPLE", Status6:Status58, @cell <> "Close")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
=SUMIFS([AS Sold Budget]6:[As Sold Budget]58,[Color Status]6:[Color Status ]58,@cell="PURPLE",Status6:Status58,@cell<>"Close")
Bassam,
I enter the formula and I received a #UNPARSEABLE. Any Suggestions?
Regards,
ds
-
Please check the column names if it's as in my formula, or if you can share me as an admin on a copy of your sheet (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Bassam,
I have shared the sheet with you. Please review and advise.
ds
-
Bassam,
Your suggestion worked. Thank you for your help!
DS😀
-
Great help! 5 stars
-
If I copy the formulas to another cell, it doesn't work. For example, I want to copy the formula to [As Sold Budget]74 and etc.
Thoughts?
-
Please share again to fix it for you
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
The formula for As Sold Sales is fixed please check it
=SUMIFS([As Sold Sales]7:[As Sold Sales]59, [Color Status]7:[Color Status]59, @cell = [As Sold Budget]@row, Status7:Status59, @cell <> "Close")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
I want to put the formula and copy as follows:
PURPLE 7[As Sold Budget]59 (CEll 74)
GREEN 7[As Sold Budget]59 (Cell 75)
YELLOW 7[As Sold Budget]59 (Cell 76)
RED 7[As Sold Budget]59 (Cell 77)
Then move to Current Budget, Current Est, Current Sales.
Regards,
-
Bassam,
That worked, thank you for your help!
Regards,
ds😁
-
Excellent 😀
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!