View Single Post
  #4   Report Post  
BIYB
 
Posts: n/a
Default

Thank you....but I dont understand the formula you suggested. Could you give
me the explanation?

"Bernie Deitrick" wrote:

=SUMPRODUCT(A4:A200*(MOD(ROW(A4:A200),4)=0))

--
HTH,
Bernie
MS Excel MVP


"BIYB" wrote in message
...
I have a workbook, where multiple forms repeat themselves 50 time or so on
the same worksheet. On one page I summarize certain information contained in
those forms. Is there an easier way then to add them one at a
time....A4+A8+A12+A16+A20...etc etc (50 time over). They are all the same
amount of cells apart.

Tks