Forum Discussion

Realfine's avatar
Realfine
Copper Contributor
Apr 17, 2024

Formula Question

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!

Formulas and Functions
    • Realfine's avatar
      Realfine
      Copper Contributor
      Apr 17, 2024

      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?

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Apr 19, 2024

        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.

Share