Practice / Conditional totals

Difficulty 3 of 5 · about 4 min

Average order value for one channel and country, rounded

Orders are in A2:C11: sales channel in column A, country in column B and order value (GBP) in column C. The channel to analyse is typed in E2 and the country in F2. In G2, write a formula that returns the average order value for rows matching BOTH the channel and the country, rounded to 2 decimal places.

Loading grid…