Sum of awarded amounts associated with clients name in range of cells


I am trying to generate sum of what each of our clients have us quote during the year and what is actually awarded and put into a Dashboard. I am having issues with the formula, any help would be greatly appreciated on what I am doing wrong, thank you.

=SUMIFS(Cost:Cost,>0, Customer:Customer, "A",sales stage:sales stage,OR(@cell = "Awarded",@cell = "closed won"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!