Trying to find a value in Smart Sheet column the add up a Column
Options
If {Build location} = AK then sum {WIP Calculation}.
Tried this is says incorrect argument what is wrong
=SUMIFS({Build Location}, "AK", {WIP Calculation})
Best Answer
-
you are using the syntax of sumif for a sumifs. change it to sumif, and if your references are correct, it should work.
Answers
-
you are using the syntax of sumif for a sumifs. change it to sumif, and if your references are correct, it should work.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!