All Posts

Google Sheets Formula for Sales Tracking Dashboard

2026-03-18

Total Revenue by Month

Use SUMIFS to total sales for a specific month. Assume dates in column A, amounts in column C:

=SUMIFS(C:C, A:A, ">="&DATE(2026,3,1), A:A, "<"&DATE(2026,4,1))

Month-over-Month Growth

Calculate percentage change between two months:

=(B3-B2)/B2

Progress to Target

Show how close you are to a sales target in cell E1:

=SUM(C2:C100)/E1

Top Salesperson

Find the salesperson with the highest total sales:

=INDEX(B:B, MATCH(MAX(C:C), C:C, 0))

Generate formulas instantly

Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.

Try FormulaWiz Free