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
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 63 Global Discussions
 66 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!