Mortar comes in 80-pound bags, and a bag lays a predictable number of block. Count the block, divide by the yield, and round up — running short mid-course means a stiff joint and a trip to the yard.
480 standard block at about 33 per bag is 14.5 bags — so you buy 15.
The example
Three walls with their block counts, all using a mortar yield of 33 block per bag.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Wall | Blocks | Per bag | Bags |
| 2 | Garden wall | 480 | 33 | 15 |
| 3 | Planter | 320 | 33 | 10 |
| 4 | Retaining | 900 | 33 | 28 |
The formula
ROUNDUP converts the fractional bag count into whole bags to buy:
How it works
One division, always rounded up:
B2/C2divides the block count by the per-bag yield — 480 over 33 is 14.5.ROUNDUP(...,0)makes that 15, because you cannot buy half a bag of mortar.- Keep the yield in its own cell — type S, type N, and different block sizes change how far a bag goes.
Around 33 block per bag is a common figure for standard 8 by 8 by 16 CMU with a 3/8-inch joint, but it swings with joint size and block type. Pin it down on your own first course.
Try it: interactive demo
Enter the block count and how many blocks one bag of mortar sets.
Variations
Add sand by the shovel
Type S mortar mixes roughly a bag of mix to a set volume of sand; scale sand with the bags.
Bags with a waste factor
Pad for droppings and a fat last joint.
Pitfalls & errors
Do not round the bag count down. A wall that needs 14.5 bags and gets 14 stops with two courses to go and no mortar to finish them.
Yield drops fast with wider joints. A 1/2-inch joint uses noticeably more mortar than 3/8, so measure your actual joint before trusting a book number.
Practice workbook
Frequently asked questions
How many block does a bag of mortar really lay?
What about brick instead of block?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class