Summing every third cell
"Alan Beban" skrev i en meddelelse
...
Leo Heuser wrote:
Or in one cell:
=SUMPRODUCT((A3:A200)*(MOD(ROW(A3:A200)-ROW(A3),3)=0))
I take it that to sum A2,A5,A8,etc., it should be A2 instead of A3?
Alan Beban
You're not a man easily fooled <g
Thanks.
LeoH
|