View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default How do I sum numbers thru specifying the amount from another cell?

Hi!

Try this:

The range of numbers is A1:A10. There can be no empty cells within the
range. B1 is the cell where you enter the number of cells to sum.

=SUM(A1:INDEX(A1:A10,B1))

Will there always be a number of cells that is at least equal to the number
selected? For example, you only 5 numbers in the range but the number
entered in cell B1 is 10?

Biff

"William" wrote in message
...
So this is what I was wondering on how to do:

I have a set of numbers, and I want to sum them, BUT I don't always want
to
sum all of them. The amount to sum is specified thru another cell, and I
am
always summing the numbers in order. Ex. if I type in a cell "5", it'll
sum
the first 5 numbers, but if i type in 10, it'll sum the first 10 numbers.
So
basically, the numnbers to sum are dependent on the number you input in
the
one cell. I tried looking at SUMIF, but that only returns the sum if the
corresponding row of another column meets a criteria. The criteria for my
case is in the one cell. What equation do I use?