OmniDocBasic Math Formulas in Excel: Add and Subtract
Learn the Excel formulas for math you need to add and subtract across cells and columns, with checks that catch common total errors.
If you searched for excel formulas for math, you probably need a total that updates when the numbers change. Maybe you are adding a monthly expense column, subtracting refunds from sales, or tracking a running balance. Most of that work comes down to a few operators and one function.
This guide shows you how to add and subtract across single cells, ranges and whole columns. You will also learn how to copy those formulas down a sheet and how to check that the result is right. If your numbers start in a PDF table, you will see one way to move them into a spreadsheet first.
You do not need prior experience. Each step uses a small example you can type in yourself, such as a 12-row expense list.
Which Excel formulas for math add and subtract? The short answer
Start the formula with an equals sign. Use plus (+) and minus (-) between individual cells, and use SUM for ranges and whole columns.
| Your situation | What to do | Why |
|---|---|---|
| Two or three specific cells | =A1+B1 or =A1-B1 | Simple operators are easy to read and audit |
| A column or block of cells | =SUM(B2:B50) | One formula covers every cell in the range |
| Subtracting several values from one number | =A1-SUM(B1:B3) | Adds the deductions first, then subtracts once |
| A running total down a column | =C2+B3, copied down | Each row adds its value to the total above it |
| Numbers stored as text | Re-enter them as numbers | SUM skips text, so the total comes out too low |
Before you start
- Put one value in each cell. A number typed inside a note such as "12 apples" is read as text, and SUM will skip it. Keep numbers in their own cells.
- Keep headers out of the range. Start the range at the first data row, such as B2 rather than B1. A header is text, so including it adds nothing, but it can shift the range by mistake.
- Decide your sign convention. Choose whether refunds are negative or positive before you subtract. A formula does exactly what you tell it, so mixed conventions produce a wrong balance.
- Get the numbers into a spreadsheet. If your figures are in a PDF, the OmniDoc desktop client can export a PDF to Excel from its PDF editor. Retyping a table invites mistakes, so export when you can. If the PDF is a scan, run OCR first so the numbers become selectable text.
- Plan a small test sheet. Build the formulas on a 12-row sample before using your real data. You can compare the result with a manual calculation and fix problems without touching your working file.
Adding and subtracting in Excel, step by step
- Click the cell where the result should appear. Many people place totals directly below a column or in a separate summary cell so they are easy to find.
- Type an equals sign. Without it, the spreadsheet stores your text instead of calculating it.
- For two cells, type a plus or minus sign between references. Enter =A1+B1 to add or =A1-B1 to subtract, then press Enter. The result updates whenever either input changes.
- For a column, type =SUM( and select the range. Type B2:B13 or drag across the cells, close the parenthesis and press Enter. SUM ignores blank cells, so an empty row will not break the total.
- Subtract a total from a starting value. Put the starting figure first, as in =A1-SUM(B2:B4). A budget minus its expenses reads left to right, which keeps the logic easy to follow.
- Copy the formula down the column. Drag the small handle at the corner of the cell, or copy and paste. Relative references shift row by row, so each row uses its own numbers.
- Lock a fixed cell with dollar signs. If a reference must stay on one cell when you copy it, put a dollar sign in front of its column letter and another in front of its row number. For example, the cell in column B, row 1 is written with both signs, so it does not move when you copy the formula down or across.
- Build a running total. Type =B2 in C2, then enter =C2+B3 in C3 and copy it down. Each row adds its value to the row above, so the last cell shows the cumulative sum.
Check every figure against the source after an OCR or export step, because recognition can misread digits.
Check the result
Once the formulas are in place, verify the totals before you rely on them.
| Check | How to see it | If it's wrong |
|---|---|---|
| The range covers every row | Click the formula cell and look at the highlighted range | Extend the range. A range that stops at row 12 drops row 13. |
| Numbers are stored as numbers | Compare =COUNT(B2:B13) with =COUNTA(B2:B13) | If COUNT is lower, some entries are text. Re-enter them as plain numbers. |
| Signs are correct | Add three or four values by hand and compare | Swap the order in the subtraction or flip the sign of the input. |
| Copied references stayed fixed | Click a copied cell and read its formula | Add dollar signs to the cell that should not move. |
| No error codes appear | Look for values such as #REF! | A reference points to a deleted cell. Rewrite the formula with a valid reference. |
❓ FAQ
1. Can I subtract one whole column from another?
Yes. In the first row of results, write =B2-C2 and copy it down. Each row subtracts its own pair of cells.
2. Why does my SUM show 0 or a number that is too low?
The values are probably stored as text, or the range points at empty cells. Use the COUNT check in the table above to see how many entries the formula actually reads.
3. Does SUM count blank cells?
Blank cells are treated as zero, so they do not change the total. The risk is a blank cell where you expected a value, which is why a quick count helps.
4. Is there a way to add a column without typing the formula?
Many spreadsheet apps offer a shortcut that fills in SUM for a selected range. The result is the same formula, so check the range it picked.
5. Should I write formulas before or after exporting a PDF table?
Export first, then write your formulas, and compare the exported values with the PDF. This keeps the formula logic separate from the copied data.
📝 Summary
Excel formulas for math start with an equals sign, use plus and minus for individual cells, and use SUM for columns. Lock fixed cells, keep numbers out of text, and check each total against a count or a quick manual estimate. Those habits cover most addition and subtraction work in a spreadsheet.
