Formulae help....new to Smartsheet

Scarfy73

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.

 

 

Paul Newcome

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

 

Give this a try.

J. Craig Williams

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 Newcome

Thanks J.

 

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