Count numbers, text, logical values and blank-like cells
Enter B13 as a real IF controlled by Boolean H2: TRUE returns empty text and FALSE returns Recorded. Keep B2:B12 as eleven editable stored observations. Fill F2:F13 separately. F2 counts physical cells, F3 numeric values, F4 nonempty cells, F5 true blanks plus formula empty text, F6 text, F7 logical values and F8 true blanks only. F9 reports the overlap F4+F5-F2. F10:F12 count numeric zeroes, positives and negatives without coercing text or Booleans. F13 sums the disjoint numeric/text/logical/true-blank counts and must reconcile with physical slots. Source numbers and the threshold are finite within ±1,000,000; editable text is nonempty text up to 40 Unicode characters, including spaces and numeric/error-looking text. Empty text is produced by the real B13 formula; use Blank for an actual empty source cell. Typed formula errors are outside this error-free comparison. These are reference-range rules, not direct-argument coercion rules.
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 B13 as a real IF controlled by Boolean H2: TRUE returns empty text and FALSE returns Recorded. Keep B2:B12 as eleven editable stored observations. Fill F2:F13 separately. F2 counts physical cells, F3 numeric values, F4 nonempty cells, F5 true blanks plus formula empty text, F6 text, F7 logical values and F8 true blanks only. F9 reports the overlap F4+F5-F2. F10:F12 count numeric zeroes, positives and negatives without coercing text or Booleans. F13 sums the disjoint numeric/text/logical/true-blank counts and must reconcile with physical slots. Source numbers and the threshold are finite within ±1,000,000; editable text is nonempty text up to 40 Unicode characters, including spaces and numeric/error-looking text. Empty text is produced by the real B13 formula; use Blank for an actual empty source cell. Typed formula errors are outside this error-free comparison. These are reference-range rules, not direct-argument coercion rules.
No account. No upload. Just try it.