Formulae help....new to Smartsheet
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

=SUMIFS([Column D]:[Column D], [Column A]:[Column A], 0, [Column B]:[Column B])
Give this a try.

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

Thanks J.
I could have sworn I put that in there. Good catch.
Help Article Resources
Categories
Check out the Formula Handbook template!