Excel templates / Sales summary

Sales summary template

An order list summed up by region and by product, with shares of the total and the biggest order, all with formulas.

Download the sales summary template (.xlsx). Free, no sign-up. Works in Excel 2010 and later, Excel for Mac, Excel on the web, Google Sheets and LibreOffice.

How to use it

  1. Replace the orders in columns A to F with your own (keep the headings). The summaries cover rows 2 to 21: to add more, insert rows above row 21 so the ranges grow with them.
  2. Rename the regions in H3 to H6 and the products in H11 to H14 to match your data.

How it works

Learn the skills behind it

Functions used: SUMIFS, COUNTIFS, SUM, IF, MAX, INDEX, MATCH.

More free templates