Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    =SUMIFS formula with 3 criteria

    ✭
    in Formulas and Functions

    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!

    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭✭
      Answer ✓

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

      )

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭
      Answer ✓

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

      )

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions