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?
Hi
=SUMPRODUCT(D3:TL3;MOD(COLUMN(D3:TL3);3)=1)
Regards
Thank you so much, you are a life saver!