Formulae help....new to Smartsheet

07/30/18 Edited 12/09/19

Hi everyone,

I am a new user to smart sheet.  I need to do a sumif calc based on two columns of data being 'unticked' so I want to show the sum of i.e Column D but only if Column A & B remain unticked.  When a cell is ticked it means that the work has been complete etc.

Any help/advise would be greatly appreciated.

 

 

Comments

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    =SUMIFS([Column D]:[Column D], [Column A]:[Column A], 0, [Column B]:[Column B])

     

    Give this a try.

    thinkspi.com

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    Paul's answer is incorrect.

    The second criterion range needs a criterion.

    =SUMIFS([Column D]:[Column D], [Column A]:[Column A], 0, [Column B]:[Column B], 0)

    To be clear, this formula will sum if BOTH A and B are unticked. If EITHER are ticked, the value in D will not be added to the total.

    If that is not what was asked for, please clarify.

    Craig

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Thanks J.

     

    I could have sworn I put that in there. Good catch.

    thinkspi.com

Sign In or Register to comment.