Clean up Sumif Formula

Options
Karrie Davis
Karrie Davis Overachievers Alumni
edited 12/09/19 in Formulas and Functions

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

Tags:
· Share on FacebookShare on Twitter

Comments

  • L_123
    L_123 ✭✭✭✭✭✭
    Options

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

     

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!