phendrena

06-30-2012, 01:34 AM

Hello all!

I am having a blank brain moment.

I've not used excel properly for a few years now and if i don't do anything regularly then I forget it. So I am having a blank moment and would appreciate some pointers.

I am trying to sum a list of numbers.

There are 50 numbers in the list (lets say A1:A50)

Cell B1 is for the user to enter a number from 1-50

Cell C1 displays the result of the SUM

Here is the problem - I can't work out how SUM the range based on the users input in cell B1. One user might want to only SUM the first 17 numbers and another user the first 33 numbers.

So can anyone give me the simple solution that I am looking for.

Frankly I fell stupid for asking but my ageing brain forgets :(

Thanks,

Dave

I am having a blank brain moment.

I've not used excel properly for a few years now and if i don't do anything regularly then I forget it. So I am having a blank moment and would appreciate some pointers.

I am trying to sum a list of numbers.

There are 50 numbers in the list (lets say A1:A50)

Cell B1 is for the user to enter a number from 1-50

Cell C1 displays the result of the SUM

Here is the problem - I can't work out how SUM the range based on the users input in cell B1. One user might want to only SUM the first 17 numbers and another user the first 33 numbers.

So can anyone give me the simple solution that I am looking for.

Frankly I fell stupid for asking but my ageing brain forgets :(

Thanks,

Dave