Customer Profitability
Summarise a transaction list by customer: revenue, cost, margin percentage that tolerates a customer with no revenue, ranking and the company margin.
What you will practise: Roll a transaction list up to customers with SUMIFS, calculate margin and rank, and keep the percentage from failing for a customer with no revenue.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.