# 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")

• ✭✭✭✭✭✭
Options

@aecross The SUMIF syntax is: =SUMIF(range, criteria, [range to sum (if different than the criteria range)] )

Switch your sum range around so that it's after your criteria range and criteria:

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

@aecross The SUMIF syntax is: =SUMIF(range, criteria, [range to sum (if different than the criteria range)] )

Switch your sum range around so that it's after your criteria range and criteria:

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

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭
Options

@Jeff Reisman, that worked - thank you!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!