Group posted net units by region
Enter one formula in G5. Return each region with at least one Posted row, sorted ascending, followed by its signed sum of units from C2:C9. Exclude Draft and Void rows. Show no field headings or grand total. Keep a region whose net is zero. If no row is Posted, return No posted records in one cell.
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 each region with at least one Posted row, sorted ascending, followed by its signed sum of units from C2:C9. Exclude Draft and Void rows. Show no field headings or grand total. Keep a region whose net is zero. If no row is Posted, return No posted records in one cell.
No account. No upload. Just try it.