Multiple additions
 

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

=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

have you tried to select the cell where you want the total, then type =sum(
after the first parenthesis, go to the other sheet and select the first cell
you want to add, then hold down the ctrl button and select all remaining
cells. Press Enter when you are finished selecting all of the cells, and
this will be your grand total.

Another option would be to sum one form off to the right now, but then copy
and past the formula in the same spot next to all of the remaining forms (the
same repeating row), then sum the entire column of your formulas for a grand
total.

There are lots of ways to handle it, but these are just some short and sweet
options. If you are more specific, maybe I can give you a more concise
answer.

"BIYB" wrote:

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

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

MOD(ROW(A4,A200),4)=0 is essentially looking at every fourth row in that
range, starting at A4, and by multiplying by the range, it extracts the
values of every fourth row into an array. SUMPRODUCT sums that array. See
http://www.xldynamic.com/source/xld.SUMPRODUCT.html for more details.

--
HTH

Bob Phillips

"BIYB" wrote in message
...
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