Report each group share of net units
Enter one formula in G5. Use only Posted rows. If their signed grand sum is zero, return No net units in one cell. Otherwise return an empty-text corner, sorted channel headings and sorted region rows. Each observed intersection is its signed sum divided by the same grand signed sum; a missing intersection is empty text. Return decimal proportions, no row or column totals. Shares may be negative or exceed one.
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. Use only Posted rows. If their signed grand sum is zero, return No net units in one cell. Otherwise return an empty-text corner, sorted channel headings and sorted region rows. Each observed intersection is its signed sum divided by the same grand signed sum; a missing intersection is empty text. Return decimal proportions, no row or column totals. Shares may be negative or exceed one.
No account. No upload. Just try it.