# Clean up Sumif Formula

Overachievers Alumni
edited 12/09/19

I have this formula to give me the sumif for multiple criteria I was just wondering if there is a simpler formula

=SUMIF(@{Healtcare Range 3}, @cell = "Memberships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Sponsorships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Client Seminars / Events", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Promotional Items / Giveaways", {Healtcare Range 2})

Thanks

• ✭✭✭✭✭✭

Original:

=SUMIF({Healtcare Range 3}, @cell = "Memberships", {Healtcare Range 2}) + SUMIF({Healtcare Range 3}, @cell = "Sponsorships", {Healtcare Range 2}) + SUMIF({Healtcare Range 3}, @cell = "Client Seminars / Events", {Healtcare Range 2}) + SUMIF({Healtcare Range 3}, @cell = "Promotional Items / Giveaways", {Healtcare Range 2})

Smaller:

=SUMIF({Healtcare Range 3}, or(@cell = "Memberships", @cell = "Sponsorships",@cell = "Client Seminars / Events", @cell = "Promotional Items / Giveaways"),{Healtcare Range 2})

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!