Forum Discussion

julientet's avatar
julientet
Copper Contributor
Jul 20, 2021

Étendre une formule avec un bon dans la formule

Bonjour, je cherche à étendre mes formules somme excel par des bons de 7. Ex:

D36 =SOMME(G22:M22) et la case suivante D37 =SOMME(N22:T22). Merci, bonne journée!

 

Je suis sur windows 10 et excel 2016.

excel

3 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Jul 20, 2021

    Hello julientet,

     

    Starting in cell D36, that could be:

    =SUM(INDIRECT("R22C"&ROW(A1)*7&":R22C"&ROW(A2)*7-1,FALSE))
    • julientet's avatar
      julientet
      Copper Contributor
      Jul 20, 2021

      PReagan 

      Thanks for the reply. I put the equation on my sheet and it's giving me #ref error and after trying a few things it's still not working? 

      • PReagan's avatar
        PReagan
        Bronze Contributor
        Jul 26, 2021

        Hello julientet,

         

        Is it possible that you can share your workbook? If so, please remove any sensitive information.

Resources