Group posted net units by region
Your goal: Filter order status before summing repeated regions, including returns and numeric zeroes.
Full 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.
Posted orders and returns; draft and void rows excludedChoose every Posted record
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 |
Step 1 of 4
Choose every Posted record
Rules for this step
Compare the whole status with Posted without letter case. Spaces are literal. Include matching negative and zero rows; duplicate labels do not merge physical records.