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 2...
excel
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