# formula question

Options

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)

Regards,

DS

Options

Bassam,

DS😀

Options

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,

• ✭✭✭✭✭✭
Options

Excellent 😀

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Hope you are fine, please add a copy or screenshot after removing any sensitive data.

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

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

• Options

=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

• ✭✭✭✭✭✭
edited 07/13/21
Options

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

• Options

Bassam,

ds

Options

Bassam,

DS😀

• Options

Great help! 5 stars

• Options

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?

• ✭✭✭✭✭✭
Options

Please share again to fix it for you

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
edited 07/13/21
Options

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

Options

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,

• Options

Bassam,

That worked, thank you for your help!

Regards,

ds😁

• ✭✭✭✭✭✭