Formula Question

[Realfine]

Hi

I am building an estimating sheet for commercial painting.  I am trying to build a formula where if you make a copy of the original reference cells the formula automatically adds the new copied cells to to the sum.  Is this possible?

Thanks!

[#2]

@Realfine 

Could you please clarify that on the sample. In particular, sum of what?

[#3]

@SergeiBaklan thank you for responding.

It has to do with applying a markup percentage to a sum of reference cells. The reference cells are labor hours that are calculated by a formula that takes sq ft and divides by production rate, example is =sum(b12/h12).  That value, we will call value A goes to another formula we will call "markups" to perform =sum(value A*1.17).  My question is how do i create a rule in the markups formula so when I make a copy of the value A formula it automatically adds the copy to the markups formula.

Is this possible?

[#4]

@Realfine 

Let say in cell C12 you have the formula =B12/H12 (value A). You copy it to the cell C13 which will be calculated as =B13/H13. etc.

Markup formula in some other cell could be like

=SUM(C12:C20)*1.17

But it all depends on how exactly your data is structured.