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.



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!