How do i sum cells 3 by 3 in Calc?

English
, ,
#1

I have an libreoffice calc file in wich i need to sum cells 3 by 3.I am searching for a formula that can do that.
For example, i need to add cells on the same row in a specific range(D3+G3+J3+…+TL3) without sellecting each cell one by one. Is there any way i can do that?

#2

Hi

=SUMPRODUCT(D3:TL3;MOD(COLUMN(D3:TL3);3)=1)

Regards

#3

Thank you so much, you are a life saver!

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.