David Wale
New Member
- Joined
- Sep 17, 2012
- Messages
- 25
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 1 | 1 | 1 | 2 | 2 | 3 | 4 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 7 | 8 | ||||||||||
2 | |||||||||||||||||||||||||||||||||||
3 | |||||||||||||||||||||||||||||||||||
4 | 1 | 1 | 1 | 3 | 3 | 6 | 10 | 10 | 10 | 15 | 15 | 21 | 21 | 28 | 28 | 28 | 36 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Hello forumI wish to modify the formula, (below), to give the results between S1 and AI1.
'=SUM(INDIRECT("A1:"&SUBSTITUTE(ADDRESS(1,COLUMN(),4),1,"")&"1"))' Thank you David Wale |
<colgroup><col></colgroup><tbody>
</tbody>
</strike>