Sales Tracker

Sales Tracker! Google Sheets Sales Tracker Dashboard: SUMIFS, COUNTIF & Conditional Formatting This episode shows how to build a quick Google Sheets sales tracker dashboard from a sales sheet where each sale includes a rep name in column D. You learn how to use SUMIFS to total the sales value per rep by summing the value column and matching the rep name to a dashboard cell (e.g., A2), then copy the formula down for multiple reps. You also learn how to use COUNTIF (or COUNTIFS) to count the number of sales per rep by counting how many times a rep name appears in the rep column, and how to sanity-check results using search (Cmd+F). Finally, it covers calculating average value per sale (value ÷ sales) and using conditional formatting with custom formulas using MAX or MIN to highlight top or bottom performers. 00:00 Sales Tracker Setup 00:33 Summing Rep Value 02:08 Counting Total Sales 02:49 Sanity Check Results 03:07 Averages and Insights 03:24 Conditional Formatting Winners 04:26 Wrap Up and Next Steps