if-statementgoogle-sheetssumgoogle-sheets-formulasumifs
Deduct an integer from another integer every time a checkbox is ticked
I'm currently working on a sheet that has a "Total" stat on it which will represents slots and I want that total slots number to be deducted by "1" every time a tick box is checked.
For example, there are 8 total slots and there are 8 Tick Boxes, each time a slot is consumed, a box is ticked and the total remaining slots is deducted by 1.
What would be the best way of making this happen? I understand I can enable "iterative calculations" and have something like
=SUM(F15,IF(F15>0,SUM(IF(K15,-1,0)+IF(L15,-1,0)+IF(M15,-1,0)+IF(N15,-1,0),0)))
I'm a total spreadsheet noob but there has to be a more consolidated way to do it.
[Example image of total with tick boxes.]
Solution
try this:
=8-SUMPRODUCT(B1:E2)
- A Return inside and outside an If Statement
- How can I use "*ngIf else"?
- How to check repeated letters in a string c#
- How to create an 'empty if statement' in Python
- How to avoid if statement? for the compiler cannot optimize it to simd
- Test if it exists a node HXT
- python else statement causes a continuous loop
- Series of if vs else-if statements benchmarking
- Google Sheets - make a list of the names in column A where column E is greater than zero
- Condition evaluation process in Java
- Excel - Array Formula to skip empty cells
- Groups of compound conditions in Bash test
- How to use the IF statement to avoid the Weather API fetch result crashing once the user types wrong the city name?
- Comparing Text with a lot of If/else
- Count cells with two conditions
- New containing div after every 3 records
- Which one of the logical AND (`&&`) and logical OR (`||`) operators take precedence over the other?
- Macro to generate chained else ifs
- Java: break statement in "if else"
- Group of conditions in IF THEN statements in VBA
- Evaluate boolean environment variable in Python
- How to check whether a mysql select statement result has a value or not in php?
- Combining multiple OR conditions with AND in Excel formula
- Writing Multiple IF <> then across multiple macros. Can this be condensed?
- T-SQL - stored procedure - "IF EXISTS" vs. "WHERE EXISTS"
- How To Check If A Number Is A BigInt In JavaScript?
- How to check the type of tkinter-widget-objects
- How can i optimize these repetitive if with queryselectors inside?
- Check if a value is within a range of numbers
- OCaml This variant expression is expected to have type unit