Parameters to sum entries

  • Thread starter Thread starter Gerry
  • Start date Start date
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
 
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
 
Back
Top