Jul 20 2021 09:40 AM
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.
Jul 20 2021 10:25 AM
Hello @julientet,
Starting in cell D36, that could be:
=SUM(INDIRECT("R22C"&ROW(A1)*7&":R22C"&ROW(A2)*7-1,FALSE))
Jul 20 2021 11:30 AM
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?
Jul 26 2021 10:25 AM
Hello @julientet,
Is it possible that you can share your workbook? If so, please remove any sensitive information.