Guided project · 5 steps Cellwise Plus
Sales by channel report in Excel
Split a month of orders by channel: revenue, share, average order value, returns, and the channel that pays most.
You will use: SUMIF, SUM, ROUND, AVERAGEIF, COUNTIF, COUNTIFS, MAX, MATCH, INDEX
Starting data
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Channel | Items | Revenue | Returned | Channel | Revenue | Share | Avg order | Return rate | |
| 2 | O-1001 | Website | 3 | 84 | No | Website | |||||
| 3 | O-1002 | Marketplace | 1 | 28 | Yes | Marketplace | |||||
| 4 | O-1003 | Shop | 2 | 92 | No | Shop | |||||
| 5 | O-1004 | Website | 1 | 64 | No | ||||||
| 6 | O-1005 | Marketplace | 4 | 76 | No | Top channel | |||||
| 7 | O-1006 | Website | 2 | 119 | Yes | ||||||
| 8 | O-1007 | Shop | 1 | 22 | No | ||||||
| 9 | O-1008 | Marketplace | 2 | 46 | No | ||||||
| 10 | O-1009 | Website | 5 | 141 | No | ||||||
| 11 | O-1010 | Shop | 3 | 70 | No |
Build it step by step
Step 1
Total revenue for each channel. Write it in H2 so it fills down to H4.
Step 2
Each channel's share of all revenue, in I2. Fill to I4.
Step 3
Average order value per channel, rounded to cents, in J2. Fill to J4.
Step 4
Return rate per channel: returned orders divided by all orders in that channel. Write it in K2, fill to K4.
Step 5
Name the channel with the most revenue in H6.