Total three amounts if all are numbers
Add 120.00, 15.50 and 9.75 into 145.25, and flag a blank or text amount.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | COUNT(A8:C8)=3 | Checks that all three cells hold numbers. | Yes, 3 numbers |
| 2 | SUM(A8:C8) | Adds the three amounts. | 145.25 |
| 3 | "Review missing or text amount" | Shown when a cell is blank or holds text. | Not used for row 8 |
| 4 | IF( … ) | Uses part 2 if part 1 says yes, else part 3. | 145.25 |
COUNT skips blanks and text, but a real zero still counts. The amounts are made-up.
=IF(COUNT(A8:C8)=3,SUM(A8:C8),"Review missing or text amount")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own amounts. Paste three amounts per row into the green columns of the Template tab. The totals fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Fill all three amounts with real numbers. A missing or text amount is flagged, not counted as zero.
Microsoft's help: COUNT function
OTHER ROUTES YOU MIGHT LIKE

Show tiny negative amounts as $0.00
-0.004 → $0.00
Get the template →
Pad an amount with stars to a set width
12.34 with width 10 → *****12.34
Get the template →
Round amounts down to set decimals
-12.345 to 2 decimals → -12.35
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →