What do you mean by "Total", do you mean just Sum? If so, let's say your
data is in the range A1:A1200 and you want to sum every 3rd line, starting on
row 3, you can use this function, entered CTRL+SHIFT+ENTER:
=SUM(IF(MOD(ROW(A1:A20),3)=1,A1:A20,""))
Change to fit your data.
--
Regards,
Dave
"David" wrote:
I need to pick a cell every 3 line and have them total , and I have 1200
lines, so picking each one would be very trying, is there a easy to do this.
The 2 lines between also have values, but I do not want to total them.
|