=SUMIFS formula with 3 criteria

claudia.alay

Hello, currently I have a working SUMIFS formula adding revenue from column A based on the status in column B, so my formula is:

=SUMIFS({Revenue Column}, {Status Column}, "Completed")

But now I have a master data list that separates projects into internal and external, I need to add to my current formula to only count revenue based on status AND if they are internal/external

the new formula i wrote was:

=SUMIFS({Customer Type}, "Internal", {Revenue Column}, {Status Column}, "Completed")

But i am getting INCORRECT ARGUMENT, I know I am close and need to tweak. can anyone help?

Thanks!

dojones

Revenue Column needs to be first since that is what you are summing, criteria follows.

Try this:

=SUMIFS({Revenue Column}, {Status Column}, "Completed", {Customer Type}, "Internal")

)

dojones

Revenue Column needs to be first since that is what you are summing, criteria follows.

Try this:

=SUMIFS({Revenue Column}, {Status Column}, "Completed", {Customer Type}, "Internal")

)