Audit row-wise Boolean masks and counts
Your goal: Convert real Booleans to 0/1, combine row conditions with AND and OR, and reconcile counts without double-counting overlaps.
Full task requirements
Enter one formula in G5. Return the six source IDs in order, followed by four numeric 0/1 columns: Team equals F2; Ready from column C; Team match AND Ready; Ready OR Units at least F4. Team equality is case-insensitive and punctuation is literal. Add a seventh row with Total in the first column and the sum of each mask in the other four columns. Each physical source record counts once even if its ID repeats. Ready cells must be actual TRUE/FALSE values; units and threshold are finite numbers within ±1,000,000. Keep all six records, including numeric zero and signed units.
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 |
Match the chosen team
Rules for this step
Compare B with F2 using literal, case-insensitive equality. Select the ID cell of each matching physical record; duplicate IDs remain separate.