Level 2 · Check and measure the channel mix in Excel

What the sheet holds

Priya’s export has one row per year, quarter and channel, completed orders only:

column	holds
A, B	year and quarter
C	channel: app, marketplace or web
D	completed orders
E	net revenue

Three years of four quarters for three channels: 36 rows, in rows 2 to 37.

Step 1: is the export complete?

An export can be missing a quarter, or carry a channel under a second name. Two quick checks catch both (COUNTIF ignores case, so App and app would count together; casing is a job for the SQL or pandas check):

H2:H4   =COUNTIF($C$2:$C$37,G2)
H5      =SUM(D2:D37)

Each channel should appear 12 times. The orders should add up to the completed total you know from elsewhere; here, the 10,849 completed orders in the dataset.

Step 2: a year by channel table from one formula

Each cell of the table is a conditional total with two conditions: the year from column G and the channel from row 8.

H9   =SUMIFS($D$2:$D$37,$A$2:$A$37,$G9,$C$2:$C$37,H$8)

$G9 keeps the column fixed and lets the row move; H$8 keeps the row fixed and lets the column move. Written once in H9 and filled to J11, it fills all nine cells. Then the total and the share:

K9   =SUM(H9:J9)
L9   =H9/K9

Step 3: what an order is worth

A mix shift matters for revenue only if the channels’ orders are worth different amounts. The AOV divides each channel’s 2025 revenue by its 2025 orders:

H13  =SUMIFS($E$2:$E$37,$A$2:$A$37,2025,$C$2:$C$37,H$8)/H11

Reading the result

The app’s share of completed orders rose from 25.8% to 33.7% to 44.3%. Web orders fell in 2025 while the store grew, so some of the app’s gain came from web. App orders are worth about $34 less than web orders, so the shift trims revenue a little even when the order count holds.

Pitfalls

• Shares without counts hide the story; keep both columns in the table.
• $ signs: fully locked data, half-locked labels. Check two filled cells in the formula bar.
• The 2025 figures exclude 92 orders still pending at year end. Even if all of them complete, the app’s share stays at 44.3%, but say so.