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.7K Get Help
- 63 Global Discussions
- 69 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!