Formula Query

Tbech

Created a formula for counting numbers in a cell if a specific contact is listed in another column. Getting errors

=SUMIF({Tracker Range 1}, >0, [{Tracker Range 2}, FIND)"Terri", @cell)>0])

Kelly Moore

Hey

Try this as one approach.

=SUMIFS({Tracker Range 1}, {Tracker Range 1}, >0, {Tracker Range 2}, FIND("Terri", @cell) = true)

In your original formula you had a couple of opportunities. One, SUMIF can only be used with one criteria. You have two. For that reason, anytime I need a SUMIF/SUMIFS function, I prefer to use the SUMIFS (plural) function which always works even if only one criteria is needed. You also had some syntax errors and bracketing errors.

Kelly Moore

Hey

Try this as one approach.

=SUMIFS({Tracker Range 1}, {Tracker Range 1}, >0, {Tracker Range 2}, FIND("Terri", @cell) = true)

In your original formula you had a couple of opportunities. One, SUMIF can only be used with one criteria. You have two. For that reason, anytime I need a SUMIF/SUMIFS function, I prefer to use the SUMIFS (plural) function which always works even if only one criteria is needed. You also had some syntax errors and bracketing errors.

Tbech

Thanks so much!!!! This community is so very help!