Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |