SUMIFS

landon31
landon31 ✭
edited 12/09/19 in Formulas and Functions

I am trying to sum accounts receivable for individual salesmen. I have gotten to the point where I can add if the check box under [Check Received] is marked but I do not know how to sum if a check box is unmarked. So far my formula is returning 0 when it should be returning a over $100,000. This is my formula so far, =SUMIFS([Revenue Amount]1:[Revenue Amount]321, Broker1:Broker321, "Tyler", [Check Received]1:[Check Received]321, "No")

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    To sum if a checkbox is unmarked you would look for 0. The checkbox column = 0. 

     

    =SUMIFS([Revenue Amount]1:[Revenue Amount]321, Broker1:Broker321, "Tyler", [Check Received]1:[Check Received]321, "No", [checkbox columnname]1:[checkbox column name]321, 0)

    Like that. Just replace my words checkbox column name with the name of your actual checkbox column. 

     

    · 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!