repeating a formula

M

mijoda

I am creating a simple inventory that will include an item count column
and a price column. I want to total the dollar amount for each row and
then have a grand total for all of the inventory. How can I create a
formula for the row subtotals without having to re-enter the formula in
each row? Thanks:)
 
B

Bob Phillips

Enter the formula in say H1, and then move the cursor to the bottom right
corner until it changes to a black square, click and drag the formula down.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
D

Don Guillett

You might want to modify this macro to suit. Assign to button/shape.

Sub balance()
Set frng = Range("h8:h" & Range("a65536").End(xlUp).Row)
With frng
.Formula = "=h7+d8"
.Formula = .Value
End With
End Sub
 
Top