View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default

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.