Excel & Google Sheets

CPM Calculator Excel

Learn how to calculate CPM in Microsoft Excel and Google Sheets with copy-paste formulas. Use the live spreadsheet-style calculator below, then apply the same formulas in your own spreadsheets.

X
cpm_calculator.xlsx
D2
fx
=(B2/C2)*1000
A
B
C
D
1
Campaign
Ad Spend ($)
Impressions
CPM ($)
2
$5.00
3
Campaign B
1,200
300,000
$4.00
4
Campaign C
800
250,000
$3.20
Sheet1 Benchmarks
Result: Your CPM per 1,000 impressions

Excel & Google Sheets CPM Formulas

Copy-paste these formulas directly into your spreadsheets. Each uses standard cell references.

A1
Basic CPM Formula
=(B2/C2)*1000
Where B2 = Ad Spend, C2 = Impressions. Calculates cost per 1,000 impressions.
B2
Ad Spend from CPM
=(B2*C2)/1000
Where B2 = CPM, C2 = Impressions. Reverse-calculates total ad spend.
C3
Impressions from CPM
=(B2/C2)*1000
Where B2 = Ad Spend, C2 = CPM. Calculates impressions delivered.
D4
eCPM (Multiple Sources)
=(SUM(B2:B10)/SUM(C2:C10))*1000
Sums all revenue and all impressions, then calculates effective CPM across rows.
E5
Blended CPM (SUMPRODUCT)
=SUMPRODUCT(B2:B10,C2:C10)/SUM(C2:C10)
Weighted average CPM where B = CPM column, C = Impressions column.
F6
CPM with Currency Format
=TEXT((B2/C2)*1000,"$#,##0.00")
Calculates CPM and formats as currency with 2 decimal places.

What is CPM Calculator Excel?

A CPM Calculator Excel guide teaches you how to calculate Cost Per Mille directly in Microsoft Excel or Google Sheets using simple formulas. While our online calculator above gives you instant results, building your own Excel CPM calculator lets you analyze large datasets, compare campaigns, and create custom dashboards.

Excel CPM calculators are essential for media planners, marketing analysts, and ad operations teams who need to process hundreds of campaigns simultaneously, track CPM trends over time, or integrate CPM calculations into larger reporting workflows.

Below you'll find step-by-step Excel formulas for CPM, ad spend, impressions, eCPM, and campaign comparison — ready to copy-paste into your own spreadsheets. Each formula includes cell references you can adapt to your data structure.

CPM Calculator Excel Formula

=( B2 / C2 ) * 1000
Excel: Solve for Ad Spend
=( B2 * C2 ) / 1000 — where B2=CPM, C2=Impressions
Excel: Solve for Impressions
=( B2 / C2 ) * 1000 — where B2=Ad Spend, C2=CPM
Excel CPM Formula Step-by-Step

In Excel, if cell B2 contains Ad Spend ($500) and cell C2 contains Impressions (100,000), enter this formula in cell D2: =(B2/C2)*1000. Result: $5.00 CPM. To apply to multiple rows, drag the formula down. For eCPM with mixed revenue, use: =(SUM(B2:B10)/SUM(C2:C10))*1000.

B2
Cell containing Ad Spend or Revenue
C2
Cell containing Impressions count
D2
Output cell for CPM result

Excel CPM Calculation Workflow

The step-by-step process for setting up a CPM calculator in Microsoft Excel or Google Sheets.

Excel: =(Ad_Spend / Impressions) * 1000

Excel CPM Calculator Best Practices

Tips for building robust, error-proof CPM calculators in Excel and Google Sheets.

A well-built Excel CPM calculator saves hours of manual work. Follow these best practices to create reliable, reusable spreadsheets.

Your Progress
0 / 6 strategies
Wrap CPM formulas in IFERROR: =IFERROR((B2/C2)*1000, 0). This prevents #DIV/0! errors when impressions are zero or blank.
Name your columns (Ad_Spend, Impressions, CPM) so formulas read like =(Ad_Spend/Impressions)*1000 instead of cryptic cell references.
Apply color scales to CPM results: green for low CPMs, red for high CPMs. This instantly highlights which campaigns are most/least cost-efficient.
Use pivot tables to aggregate CPM by campaign, platform, date, or ad format. This reveals trends and patterns that raw data tables can't show.
Set data validation on input cells: Ad Spend must be ≥ 0, Impressions must be > 0. This prevents accidental errors that break CPM calculations.
Google Sheets supports the same CPM formulas as Excel and enables real-time team collaboration. Use IMPORTRANGE to pull data from other sheets automatically.

CPM Calculator Excel FAQ

Common questions about calculating CPM in Excel and Google Sheets.

The Excel formula for CPM is: =(Ad_Spend/Impressions)*1000. If Ad Spend is in cell B2 and Impressions in C2, enter =(B2/C2)*1000 in the CPM cell. This calculates Cost Per Mille (cost per 1,000 impressions).

Enter each campaign in a separate row with Ad Spend and Impressions columns. Apply the CPM formula to each row: =(B2/C2)*1000, then drag down. For blended CPM across all campaigns, use: =SUMPRODUCT(B2:B10,C2:C10)/SUM(C2:C10).

Yes! Google Sheets uses the same formula syntax as Excel. =(B2/C2)*1000 works identically. Google Sheets also supports SUMPRODUCT, IFERROR, and all other functions mentioned in this guide.

Use IFERROR: =IFERROR((B2/C2)*1000, 0) or =IFERROR((B2/C2)*1000, "N/A"). This returns 0 or "N/A" instead of an error when Impressions is zero or blank. Always wrap CPM formulas in IFERROR for clean spreadsheets.

Yes! Create columns for: Campaign Name, Ad Spend, Impressions, CPM (formula), eCPM, and Notes. Add conditional formatting, data validation, and a summary row with blended CPM. Save as an .xlsx template to reuse across projects.