Once you have ten or twenty numbers to add, tapping "+" over and over is asking for trouble. One mistyped digit and you have no way to find it β you just start over. This article shows how to add up multiple numbers automatically using aggregate functions like SUM, AVG and MAX. It's for the moments when a spreadsheet is overkill but a plain calculator isn't enough.
Download MonoTape for free Write your numbers, drop in SUM() and the total appears. No more retyping long additions. Free, no sign-up.
Why adding a list of numbers on a calculator is painful
Receipt line items, expense claims, monthly bills β lists of numbers are everywhere. A standard calculator handles them badly for three reasons.
No visible progress
The screen only shows the current number. You can't tell how many you've entered or which one you skipped.
One fix means starting over
Spot a wrong figure three entries back and there's nothing to edit. You retype the whole list.
No average or maximum
You can reach a total, but "average per item" or "the biggest one" means entering everything again.
All three come down to the same thing: the numbers you typed don't stick around. Flip that β keep every entry as a row β and totals, averages and comparisons become available at any time.
SUM() totals the rows above it, automatically
MonoTape is a notes-style calculator: each calculation becomes a row on a running tape. Type SUM() on a new row and it adds up the consecutive rows directly above it. Four numbers or forty, it's the same single step from the fx button.
βΌ Grocery run
Milk 3.80
Eggs 4.20
Bread 2.50
Detergent 7.90
------------------------
SUM() 18.40 β totals the four rows aboveYou never specify a range. Put SUM() after the numbers and it collects them. Add another item and the total grows with it.
Note rows are skipped. Headings like "July" or "Groceries from here" are left out of the total automatically, so you can break a long list into readable sections without breaking the math.
Seven aggregate functions, one gesture
MonoTape ships with seven aggregate functions. They all read the same "consecutive rows above" range, so if you can use SUM() you can use all of them.
| Function | What it returns | Example |
|---|---|---|
| SUM() | Sum of consecutive rows above | 100, 200 β 300 |
| TOTAL() | Sum of all SUM() rows in the tape (grand total) | SUM()=120, SUM()=80 β 200 |
| AVG() | Average of consecutive rows above | 100, 200 β 150 |
| COUNT() | Number of consecutive rows above | 100, 200, 300 β 3 |
| MIN() | Smallest of consecutive rows above | 300, 100, 200 β 100 |
| MAX() | Largest of consecutive rows above | 300, 100, 200 β 300 |
| MEDIAN() | Median of consecutive rows above | 100, 200, 900 β 200 |
Write down a week of lunch spending and you can get the weekly total with SUM(), the per-meal average with AVG(), and the priciest day with MAX() β three extra rows, zero re-entry.
Sum, average and max in one tap Pick a function from the fx sheet β no syntax to memorize. Free on iPhone and Android.
Subtotals with SUM(), grand total with TOTAL()
SUM() stops when it reaches another aggregate row. In practice that means every SUM() closes off a group as its own subtotal. Finish with TOTAL() and it adds up only the SUM() rows.
βΌ Trip budget by category
[Travel]
Flights 420.00
Local trains 48.00
SUM() 468.00 β travel subtotal
[Lodging]
Hotel 2 nights 260.00
SUM() 260.00 β lodging subtotal
[Food]
Dinners 96.00
Lunches 42.00
SUM() 138.00 β food subtotal
------------------------
TOTAL() 866.00 β subtotals only, nothing double-countedAdding line items and subtotals by hand invites double-counting. TOTAL() only picks up the SUM() rows, so it can't happen. There's more on category budgets in breaking a travel budget down by category.
Going further: totals by range or by label
When the rows you want aren't next to each other, name them inside the parentheses.
SUM(#2:#8) Adds rows 2 through 8 (range form)
SUM(#1, #3, Rent) Adds row 1, row 3 and the row labeled "Rent" (list form)
Because MonoTape lets you label any calculation row, you can pull out "just this category" regardless of where those rows sit on the tape. Labeling is covered in calculator history as notes.
Rounding and remainders are covered too
Beyond aggregates, the functions that earn their keep day to day are rounding and remainders.
| Function | Use it for | Example |
|---|---|---|
| ROUND(value, digits) | Rounding a split bill to a sane figure | ROUND(3.14, 1) β 3.1 |
| CEIL(value, digits) | Rounding materials up to what you must buy | CEIL(3.14, 1) β 3.2 |
| FLOOR(value, digits) | Rounding rewards or points down | FLOOR(3.98, 1) β 3.9 |
| MOD(a, b) | The leftover when a bill won't divide evenly | MOD(10, 3) β 1 |
| INT(value) | Dropping to a whole number | INT(3.98) β 3 |
| SQRT / POW / ABS | Square root, powers, absolute value | POW(2, 3) β 8 |
There's more where that came from: LN, LOG10, GCD, LCM, factorial, the trig functions (SIN, COS, TAN and their inverses) plus constants like Ο and e. Everything is grouped in the fx sheet under Aggregate, Rounding, Numeric and Trigonometric & Constants, each with a description and a worked example, and the ones you use most collect in a Favorites row.
Change one number and every total follows
Functions pair naturally with MonoTape's automatic recalculation. Edit a source row and SUM(), AVG() and everything downstream update immediately.
βΌ Detergent corrected from 7.90 to 8.90
Milk 3.80
Eggs 4.20
Bread 2.50
Detergent 8.90 β edit just this row
------------------------
SUM() 19.40 β total updates itself"What if I buy one more?" "What if the rate goes up?" β you can run those what-ifs endlessly without retyping a thing. See how automatic recalculation works for the details.
Where this pays off
π§Ύ Receipts and expenses
List the line items, drop in SUM(). Group by category and the subtotals transfer straight into your budget.
Summarizing receipt items later βπ Running totals while shopping
Add a row per item in the cart and watch SUM() against your budget before you reach the till.
Staying under budget while shopping βπ Fixed monthly costs
Rent, utilities, subscriptions in a column: SUM() for the total, AVG() for the monthly average.
Making fixed costs visible βπΌ Quotes and estimates
Hours Γ rate per line, SUM() per section, TOTAL() at the end. Change a rate and the quote follows.
Building a quick estimate βFrequently asked questions
Q. Do I have to memorize function names?
No. The fx button opens a sheet listing every function under Aggregate, Rounding, Numeric and Trigonometric & Constants. Each entry shows what it does and a worked example, so you can find one by purpose rather than by name.
Q. Which rows does SUM() include?
It walks upward from the row you placed it on, collecting consecutive calculation rows. Note rows are skipped, and it stops at another aggregate row such as an earlier SUM(). That's what makes per-group subtotals fall out naturally.
Q. What's the difference between SUM() and TOTAL()?
SUM() is a subtotal of the consecutive rows above it. TOTAL() is a grand total of the SUM() rows in the tape. If there are no SUM() rows, TOTAL() falls back to adding every calculation row.
Q. Do functions cost extra?
No. MonoTape is free, and that includes the full function set. No account required.
Q. Can it replace a spreadsheet?
Not for everything a spreadsheet does. But for "list some numbers, get a total and an average" or "keep the breakdown next to the grand total", opening MonoTape on your phone is far quicker than building a sheet.
Key takeaways
- ✓ Plain calculators struggle with lists because nothing you type is kept
- ✓ MonoTape's SUM() adds the consecutive rows above it automatically
- ✓ AVG, COUNT, MIN, MAX and MEDIAN work exactly the same way
- ✓ SUM() for subtotals, TOTAL() for the grand total β no double-counting
- ✓ Edit a source number and every total recalculates on its own
Stop retyping long additions
Shopping, expenses, estimates, household budgets β anywhere numbers pile up, write them down and let SUM() do the adding. Download MonoTape free and replace the "+" marathon today.
Learn more about MonoTape