For a simple list of revenue amounts, enter =SUM(E2:E100) in an empty cell, replacing E2:E100 with the range that contains your revenue figures. For a sales list that will grow, an Excel Table formula such as =SUM(Sales[Revenue]) can include new rows automatically. The formula adds the selected numbers; it does not decide whether your column represents gross sales, net revenue, invoice totals, or cash received.
Choose the right revenue values first
“Total revenue” depends on what the worksheet records. It might mean gross sales before deductions, net sales after discounts and refunds, or a different figure such as the full invoice amount or cash collected. Decide what the source column represents before totaling it. A SUM formula adds the numbers in its range; it does not apply accounting rules or confirm that the values are revenue.
The example below records one amount per sale:
| Date | Product | Units | Unit Price | Revenue |
|---|---|---|---|---|
| Jan 5 | Basic plan | 3 | 25 | 75 |
| Jan 8 | Pro plan | 2 | 60 | 120 |
| Jan 12 | Basic plan | 4 | 25 | 100 |
Use SUM for a basic total
If the revenue amounts are in cells E2:E4, enter:
=SUM(E2:E4)The result is 295. In the formula, = starts the calculation, SUM is the function, and E2:E4 is the range. The colon means “from the first cell through the last cell.” You can also sum separated ranges, for example =SUM(E2:E100,E105:E110), when the omitted rows should not be included.
SUM accepts numbers, references, ranges, or combinations of these, with up to 255 arguments, according to Microsoft’s SUM documentation.
Recommended Free Tools
Enter the formula or use AutoSum
Type the formula
- Click an empty cell where you want the total.
- Type
=SUM(, then select or drag across the revenue cells. - Type
)and press Enter. For example, the finished formula might be=SUM(E2:E100).
Excel’s formula guidance describes entering a function, selecting its range, closing the parentheses, and pressing Enter.
Use AutoSum
- Click the empty cell immediately below a contiguous revenue column.
- Select Home > AutoSum or Formulas > AutoSum.
- Inspect the highlighted range. If it omits rows or includes cells that should not be totaled, edit the range in the formula.
- Press Enter to confirm.
AutoSum inserts a SUM formula, but it guesses the range from the layout rather than understanding which figures are sales. Blank rows or columns can affect the suggested range; see Microsoft’s AutoSum steps and notes on SUM and range detection.
Make the total expand with an Excel Table
A fixed formula such as =SUM(E2:E100) is simple, but it will not include new records entered below row 100. For a recurring sales list, convert the data range to an Excel Table:
- Select a cell in the data and press Ctrl+T on Windows, or choose Insert > Table.
- Confirm My table has headers.
- Give the table a name, such as
Sales, using the table name control in Excel. - In a cell outside the table, enter
=SUM(Sales[Revenue]).
Use the exact table and column names in your workbook. If the heading is Revenue Amount, for example, write =SUM(Sales[Revenue Amount]). These structured references use labels instead of fixed cell addresses; Microsoft says they adjust as table data is added or removed. See structured references in Excel Tables. A Table makes the range easier to maintain, but it still totals whatever values are in that column.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Calculate revenue from units and price
Calculate each sale, then total the column
If column B contains units and column C contains unit prices, put this formula in the first Revenue row, such as D2:
Rank #2
- Used Book in Good Condition
=B2*C2Copy the formula down the Revenue column, then total the results with =SUM(D2:D100). In a Table, a calculated Revenue column can use =[@Units]*[@[Unit Price]]. Excel can fill a calculated-column formula through the table; see Microsoft’s calculated-column guidance.
Calculate a direct total
If each quantity in B2:B100 matches the unit price on the same row in C2:C100, you can multiply and add the pairs in one formula:
=SUMPRODUCT(B2:B100,C2:C100)This assumes matching rows and no adjustments that need separate treatment. Discounts, refunds, taxes, shipping, commissions, and currency conversions must be included in the inputs or handled separately if your intended revenue figure requires them.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Total revenue by product, region, or date
One condition with SUMIF
To add revenue for one product, use SUMIF. If products are in column B and revenue is in E, this formula totals Basic plan sales:
=SUMIF(B2:B100,"Basic plan",E2:E100)The pattern is SUMIF(range, criteria, [sum_range]): Excel checks the first range against the criterion and adds corresponding values from the sum range. A Table version is =SUMIF(Sales[Product],"Basic plan",Sales[Revenue]). See Microsoft’s SUMIF documentation.
Multiple conditions with SUMIFS
To total Basic plan revenue in the East region, assuming product is in B, region is in C, and revenue is in E:
=SUMIFS(E2:E100,B2:B100,"Basic plan",C2:C100,"East")SUMIFS starts with the range to add, followed by each criteria range and its criterion. For a Table, the corresponding formula is =SUMIFS(Sales[Revenue],Sales[Product],"Basic plan",Sales[Region],"East"). Microsoft documents this function for totals meeting multiple conditions at SUMIFS function.
Limit the total to a date range
Assuming dates are in column A and revenue is in E, this sums January 2026 sales:
=SUMIFS(E2:E100,A2:A100,">="&DATE(2026,1,1),A2:A100,"<"&DATE(2026,2,1))The second condition uses the first day of the following month as an exclusive upper limit. This includes all times on January 31 if date cells contain times. The date column must contain real Excel dates, not text that only looks like dates. With a Table, use =SUMIFS(Sales[Revenue],Sales[Date],">="&DATE(2026,1,1),Sales[Date],"<"&DATE(2026,2,1)).
Sum across monthly worksheets
If each month has the same layout and revenue is in E2, a summary sheet can use a 3-D reference:
=SUM(January:December!E2)This adds E2 across worksheets between January and December in the workbook’s sheet order. Adding or moving sheets within that span can change which sheets are included, so check the range when the workbook structure changes. For separate, noncontiguous monthly sheets, list each reference: =SUM(January!E2,February!E2,March!E2). Microsoft also describes using SUM on a summary sheet for monthly worksheets at Learn more about SUM.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errorsTroubleshoot a total that looks wrong
Check the selected range
Confirm the formula includes every transaction row and no unrelated cells. A fixed range ending at row 100 omits later records. AutoSum may stop at a blank row or select too little, so inspect its highlighted cells before accepting it.
Look for numbers stored as text
Values that look numeric but are stored as text may be skipped by a range sum. Clues include left alignment, a warning icon, or a total smaller than expected. If Excel offers it, select the warning menu and choose Convert to Number. For suitable imported data, Data > Text to Columns > Finish may also convert values. Check for leading apostrophes, currency symbols entered as text, or nonbreaking spaces before converting; do not assume a display format alone fixes the underlying value.
Check for errors and missing numeric entries
An error such as #VALUE!, #N/A, or #DIV/0! in the summed data can make the result an error. You can compare the numeric-cell count with the expected number of transactions using =COUNT(E2:E100), then inspect missing, text, and error cells. Replacing every error with zero can hide a data problem, so identify the source before deciding how to handle it.
Do not add transactions and their subtotals together
If a column contains both transaction amounts and subtotal rows, a whole-range sum counts the transactions and then counts their subtotals again. Sum only transaction rows, keep subtotals outside that range, or use a consistent Table with a separate Total Row.
Free tools Windows power users keep installed
One-click scans. No signup required.
Best Value
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
Choose a visibility-aware function for filtered rows
=SUM(E2:E100) totals the range regardless of a filter. For a filtered list where you want the visible subtotal, use =SUBTOTAL(9,E2:E100); function number 9 means SUM, and SUBTOTAL excludes rows removed by a filter. If manually hidden rows should also be excluded, use =AGGREGATE(9,5,E2:E100): function 9 is SUM and option 5 ignores hidden rows. These choices concern visibility, not the meaning of revenue.
Keep the total formula outside the range it adds
Do not put a formula such as =SUM(E:E) in column E itself: the range includes the formula cell and creates a circular reference. Put the total outside column E or use a range that ends above the total, such as =SUM(E2:E100) in E101.
Check signs, currencies, and formatting
Negative values reduce the total. That works for refunds or credits only if your workbook records them as negative amounts; positive refund entries need to be deducted separately if the intended total is net of refunds. Do not aggregate different currencies as if they were one: convert amounts under a consistent exchange-rate rule before totaling. Applying a currency format changes how a number is displayed; it does not convert the currency. Also decide whether rounding belongs on each transaction or only on the final total.
Excel version and formula separators
Microsoft lists SUM and SUMIFS for Excel for Microsoft 365, Excel for the web, Excel 2024, 2021, 2019, and 2016, among other listed editions; exact interface details vary by platform and edition. See Microsoft’s current pages for SUM and SUMIFS.
Depending on regional settings, Excel may require semicolons rather than commas between function arguments. For example: =SUMIFS(E2:E100;B2:B100;"Basic plan";C2:C100;"East"). Use the separator Excel inserts when you select arguments.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
