Try the below to sum B1 to the number of rows specified in A1

=SUM(OFFSET(B1,0,0,A1,1))

If this post helps click Yes
---------------
Jacob Skaria


"Elton Law" wrote:

Hi Expert,
I think you have heard this term before in Finanical market- technical
analysis.
I have a series of stock price data.
Is it possible that say I put a number 6 in a cell and then it can sum 6
rows data and then divide by 6 too.
Another example .... I put 9 in cell A1.
Stock price series data in B1 to B20 ... it will sum B1 to B9 and then
divide by 9 too.
Look like it is conditional sum depending on the number in a cell.
Thanks