Using a Checkbox in a Formula

aecross

Hi there -

I have a formula =SUM(COLLECT({MASTER TRACKING SHEET Range 29}, { MASTER TRACKING SHEET Range 24}, "Arizona"))

that I want to incorporate a checkbox column {MASTER TRACKING SHEET Range 28} into.

So, I'm looking for the sum of range 29 where range 24 is Arizona and range 28 is CHECKMARKED.

Thank you!

Jeff Reisman

@aecross For this one, you'll want to use the SUMIFS function, because it allows you to specify multiple criteria that must be true. Keep in mind that for SUMIFS, the range you want to sum always comes first in the formula, before the criteria ranges and criteria. I'm not sure why you have COLLECT in there, but you don't want it in this formula.

=SUMIFS({MASTER TRACKING SHEET Range 29}, {MASTER TRACKING SHEET Range 24}, "Arizona", {MASTER TRACKING SHEET Range 28}, 1)