Values Adding

[Jane]

I have a problem on my spredsheet now. Since I don't want to use "+" to add up some values, would anybody let me know how to add up values in a column after every five 3 lines?

Thank you!

[Bob Phillips]

five 3 lines, I assume you mean every 3 lines


=SUMPRODUCT(--(MOD(ROW(A1:A100),3)=0),A1:A100)

[brettdj]

What row does your data start in?

[Jane]

Values from the first one then after every three lines. Thanks!

[Bob Phillips]

=SUMPRODUCT(--(MOD(A1:A30,3)=1),A1:A30)

just adjust A30 to the end of your range