Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Columm sums
Hi all
Thanks for help in the past & future I have a columm of numbers to be added There are about 1200 of these running say from cells C1 down to C1200 I normally use the =SUM(C1:C1200) function but often I only want to total part of these - say from cells 250 to 650 I usually manually change the function each time - I am wondering if there is some function I could use where I could input say into cells B1 and B2 the numbers of the range of cells in the C columm I want to be totalled Many Thanks Alex |
#2
|
|||
|
|||
Columm sums
Hi Alex,
If cell A1 contains the row no to start from - say 6 and cell A2 has the row no to end at - say 12 Then =ADDRESS(A1,3) gives $C$6 =ADDRESS(A2,3) gives $C$12 and =SUM(INDIRECT(ADDRESS(A1,3)):INDIRECT(ADDRESS(A2,3 ))) sums C6:C12 Ed Ferrero http://edferrero.m6.net/ Hi all Thanks for help in the past & future I have a columm of numbers to be added There are about 1200 of these running say from cells C1 down to C1200 I normally use the =SUM(C1:C1200) function but often I only want to total part of these - say from cells 250 to 650 I usually manually change the function each time - I am wondering if there is some function I could use where I could input say into cells B1 and B2 the numbers of the range of cells in the C columm I want to be totalled Many Thanks Alex |
#3
|
|||
|
|||
Columm sums
Another way:
=SUM(INDEX(C1:C1200,B1):INDEX(C1:C1200,B2)) Biff "Alex McKenzie" wrote in message ... Hi all Thanks for help in the past & future I have a columm of numbers to be added There are about 1200 of these running say from cells C1 down to C1200 I normally use the =SUM(C1:C1200) function but often I only want to total part of these - say from cells 250 to 650 I usually manually change the function each time - I am wondering if there is some function I could use where I could input say into cells B1 and B2 the numbers of the range of cells in the C columm I want to be totalled Many Thanks Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
(macro, formula,...) To Copy columm in various sheet's | Excel Discussion (Misc queries) | |||
Excell will not add multiple sums together, what do I have turned. | Excel Discussion (Misc queries) | |||
Replace Letter "E" with Letter "C" for 200 Different Sums in a Col | Excel Worksheet Functions | |||
LOOKUP FUNCTION WITH SUMS ABILITY | Excel Discussion (Misc queries) | |||
LOOKUP FUNCTION WITH SUMS VALUES | Excel Discussion (Misc queries) |