Sum a specific number of rows

[MisterEcoli]

I have a column of over 1000 entries, numbered 1 to 1000 in Column A with the data in Column B.

I regularly need to sum the data up to a specific point, e.g what's the sum of the first 50 entries, or first 277 entries etc..

Although I can change the formula to Sum specific rows is there anyway I can simply type a number in a cell, e.g '55' and it will sum all of the entries up to 55?

 

[SkipVought]

You could simply use the SUMIF() function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

... or you could a formula like this:

=SUM(F2:INDEX(F2:F999,J2))

assuming the cells you want to sum are in F2:F999, and cell J2 contains the 55 or whatever.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[N1GHTEYES]

See also the help on the OFFSET function.

Tony

 

[MisterEcoli]

thanks guys, all sorted, worked a treat!

 

[SkipVought]

MisterEcoli,

It is both common courtesy and proper etiquette to not only cap off your thread with "all sorted," but also to share with other Tek-Tip members exactly how you sorted out your problem, if you would, please.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}