SUMIFS

landon31

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

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.