I am trying to use the sumifs to get the total of amounts that have been paid based on certain categories but need to exclude certain submitters

The way I have tried it is below.

=SUMIFS({Paid to Date},{Category}, OR("Type 1", "Type 2", "Type 3", "Type 4"), {Submitted By}, OR("Name 1", "Name 3", "Name 5"))

I have thought about expanding it to be the sum of a bunch of sumifs but I would rather not have an excessively long formula.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!