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
Check out the Formula Handbook template!