Sum If Formula

Options

I am trying to find the sum of a column (Range 35) only if Range 24 = Arizona. I think I'm close, but can't quite get it to compute....

=SUMIF({MASTER TRACKING SHEET Range 35}, {MASTER TRACKING SHEET Range 24}, "Arizona")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!