SUMIFS

Kimberly Loveless

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.

Heather Duff

Hi @Kimberly Loveless ,

Try this:

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

Let me know if it works!

Best,

Heather

Heather Duff

Hi @Kimberly Loveless ,

Try this:

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

Let me know if it works!

Best,

Heather

Kimberly Loveless

That worked thank you. I knew there had to be a way to do it. 😁