Sum If Formula

aecross

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

Jeff Reisman

@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})

Jeff Reisman

@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})

aecross

@Jeff Reisman, that worked - thank you!!