Parameters to sum entries

G

Gerry

SUM(OFFSET(C1,0,0,A1,1))
I'm trying to adapt this formula to sum a specified number
of rows within Column C.

i.e. if column C has lots of numeric entries, how can I
specify to add inclusively just rows 10 to 20, for
example, by entering 10 and 20 in A1 and A2 respectively.

TIA
 
C

Chip Pearson

Gerry,

Try the following formula. A1 is the start row number and A2 is the end row
number.

=SUM(OFFSET(C1,A1-1,0,A2-A1+1,1))

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top