Total campaign spend by channel in Excel and Google Sheets
FormulaCraft · Reviewed 2026-09-16
Use SUMIF to add spend only for the channel you select. In this example, two Meta campaign rows contain 1,200 and 800, so the Meta total must be 2,000. Keep the channel range aligned with the spend range, and confirm that every amount uses the same currency and reporting period.
Total Meta spend
| Channel | Campaign | Spend |
|---|---|---|
| Meta | Launch | 1200 |
| Search | 1500 | |
| Meta | Retargeting | 800 |
| YouTube | Video | 500 |
Excel
=SUMIF(A2:A5,"Meta",C2:C5)Google Sheets
=SUMIF(A2:A5,"Meta",C2:C5)Expected result: 2000
Only rows 2 and 4 have channel Meta. Add their spend values: 1200 + 800 = 2000; exclude the other two rows.
Both expressions are checked against the expected result in HyperFormula. This is an engine check, not a native Excel or Google Sheets certification. The CSV contains sample data; paste the formula into an empty cell.
Prepare one consistent campaign table
Start with one row per campaign and reporting period. Column A holds the channel, column B the campaign name, and column C the spend. The downloadable sample uses fictional campaign data; paste it into a blank sheet starting at A1.
Use one reporting currency before calculating the total. Adding rupees and dollars produces a number that has no useful business meaning. Confirm the start date, end date and timezone of each export before combining rows.
Run and reconcile the channel total
Paste the example formula in a cell outside the sample table. It checks A2 through A5 for Meta and adds the matching values from C2 through C5. The expected result is 2,000.
Check that result independently: Launch contributes 1,200 and Retargeting contributes 800. The Google and YouTube rows do not contribute. Reconcile the complete table against the platform export before sharing a report.
Adapt the example to your report
Replace Meta with the channel label in your own export, and extend both ranges to the same final row. Put the output outside the input range to avoid referring to the total itself.
A channel total answers one condition. If your report also needs a specific month, market or campaign objective, use a method that supports all those conditions, such as SUMIFS or a pivot table. Do not assume this single-condition example already applies those filters.
Check the common reporting mistakes
Repeated downloads can duplicate campaign rows and inflate spend. Deduplicate using a stable campaign identifier together with the reporting period; campaign name alone may not be unique.
Check channel labels for accidental spaces and spend cells for text values. If the formula parser rejects commas, your spreadsheet locale may require semicolons. The example uses English function names and comma separators.
Common questions
Does the same example work in Excel and Google Sheets?
Both document SUMIF with a criteria range, criterion and sum range. The example uses the same expression for both. Adapt separators to your locale.
Why is the result lower than the advertising platform total?
Check the reporting dates, timezone, channel labels, filters and whether the spend values are numeric. This formula totals only the rows present in its range.
Does this remove duplicate campaign rows?
No. Duplicate input rows will be counted. Resolve them before aggregating.