Summing columns

Options

Hello,

I am trying to write a formula to look at one column in a reference sheet, and if that column equals yes, it'll total another column in that same reference sheet.

I assume an IF statement is correct, but I cannot get the syntax right.

Thanks for your help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!