Toni said:I have a worksheet with over 300 rows and 12 columns. I need to get the sum of every other number in each column. In other words, I need the system to add every other number and put it in the total box at the bottom of the work sheet. HELP!
Book2 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
2 | 6 | 21 | 6 | 12 | 10 | 14 | |||
3 | 24 | 18 | 19 | 14 | 8 | 23 | |||
4 | 17 | 20 | 18 | 14 | 13 | 19 | |||
5 | 24 | 24 | 20 | 12 | 7 | 12 | |||
6 | 22 | 10 | 15 | 18 | 7 | 23 | |||
7 | 10 | 13 | 22 | 17 | 8 | 21 | |||
8 | 21 | 24 | 10 | 8 | 10 | 12 | |||
9 | 6 | 12 | 24 | 19 | 15 | 11 | |||
10 | 6 | 19 | 10 | 12 | 18 | 8 | |||
11 | 6 | 24 | 24 | 14 | 13 | 24 | |||
12 | 19 | 12 | 18 | 18 | 16 | 17 | |||
13 | Every2ndTotals | 91 | 106 | 77 | 82 | 74 | 93 | ||
14 | 70 | 91 | 109 | 76 | 51 | 91 | |||
15 | |||||||||
Sheet1 |
inarbeth said:Nice idea but I get an error inthe formula: ...
fairwinds said:...
I was tryin to use DSUM to solve this. It appears to work as long as the criteria formula references the same row where you have the DSUM formula.
Any thoughts?
=MOD(ROW(A3),2)
=DSUM(A2:A17,1,C1:C2)
...
Aladin Akyurek said:inarbeth said:Nice idea but I get an error inthe formula: ...
Formulas do not show. So which nice idea is failing?