Thank you that did it.

"Domenic" wrote:

To sum every 3rd row beginning with the first cell in the range, try...

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

To sum every 3rd row beginning with the first occurrence of '3rd',
change '+0' to '+1'.

Hope this helps!

In article ,
"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.