Sumif using a variable


I have a simple sumif adding values from column Estimate based on some text being present in column Artist. The result is all the time allocated to a particular artist.

=SUMIF(Artist:Artist, "Alex", Estimate:Estimate)

In order to make this more compact I would like to have a pull down menu with all the artists names. The name selected from the drop down should then replace "Alex" in the formula.

Can anyone shed some light on how to set this up?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!