Reinforced block walls get vertical bars at a fixed spacing, and the count always runs one more than the number of gaps. This recipe converts the wall length to inches, divides by the spacing, rounds up and adds the end bar, then multiplies by the wall height to get total bar footage to order.
A 24-foot wall with bars every 32 inches needs 10 bars, or 80 feet at 8 feet high.
The example
Three walls at different lengths and spacings. Tighter spacing means more bars.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Case | Wall ft | Spacing in | Height ft | Bars | Total ft |
| 2 | Garden wall | 24 | 32 | 8 | 10 | 80 |
| 3 | Retaining wall | 30 | 48 | 8 | 9 | 72 |
| 4 | Warehouse wall | 40 | 24 | 10 | 21 | 210 |
The formula
Gaps between bars, rounded up, plus one for the closing bar:
How it works
Here is the logic, one piece at a time:
B2*12converts the wall length from feet to inches.- Dividing by the spacing in
C2counts the gaps between bars. ROUNDUP(...,0)rounds partial gaps up so the last section is still reinforced.+1adds the extra bar at the end because bars equal gaps plus one.
Local code or the engineer's drawings set the spacing; this formula only counts the bars.
Try it: interactive demo
Enter the wall length, bar spacing and wall height.
Variations
Add a bar at each corner and opening
Add extra bars for corners and either side of openings.
Add lap length
Add a lap length per bar if bars are spliced.
Pitfalls & errors
Forgetting the +1 leaves the last cell without a bar.
Spacing is measured center to center, and the first bar is usually placed at the wall end, not at a spacing offset.
Order bar in stock lengths and note laps so you do not buy short.
Practice workbook
Frequently asked questions
Does this include horizontal bond beam steel?
Why round up rather than to nearest?
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