1 When hiring a painting contractor, paint and supplies make up about 15-25 percent of the cost, while 75-85 percent goes for labor. 2  Costs typically average $1,500-$3,000 for an average single-story, three-bedroom home, but easily run $3,000-$5,500 or more for a multi-story or multi-level larger house. Choose the best quality paint you can afford; it lasts longer. 2  Experts estimate that the outside of a house should be painted every 5-7 years, but less-expensive paint may start peeling or fading in 4 years or less while really high-quality paint will hold up a bit longer.
Re: VBA code for suming a dynamic column range will this macro help you. VB: Sub test() Dim r As Range, j As Long, k As Long j = Range(A1).End(xlToRight).Column For k = 1 To j Set r = Range(Cells(1, k), Cells(1, k).End(xlDown)) r.End(xlDown).Offset(2, 0) = WorksheetFunction.Sum(r) Next k End Sub.
Now you can choose what is the column that you want to group (âAt each change inâ), in this case is the Store column, what is the function you want to use, we want to Sum, and what is the column that you want to sum, that is the Value column. Just click OK and your sheet will now look like this:f you click on the â2â button, you will get only the subtotals by store and the Grand Total, like this: If you click on the â3â button, you will get your complete table again. You can always click the â+â and â-â buttons to expand or collapse some of your groups.