Sum Collect if two different values met

I have added this formula:

=SUM(COLLECT({Sheet - Sales Pipeline Range 10}, ({Sheet - Sales Pipeline Range 5}, "Closed Lost"), ({Sheet - sales pipeline loss reason}, "Price")))

I am trying to sum all values from Pipeline Range 10 column that have met the criteria of "Closed Lost" with the loss reason of "Price". What have I done wrong here?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!