Audit row-wise Boolean masks and counts
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.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View 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.
No account. No upload. Just try it.