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
|