Another one:

C1 = 3

=SUM(A1:INDEX(A1:A100,C1))

If C1 is empty the formula will calculate the entire range.

--
Biff
Microsoft Excel MVP


"Menochez" wrote in message
...
So I have a column of randomly created numbers that I need to use for
financial predictions. I need to be able to say: Add from the first cell
to
the "x" number of cells.

i.e:
A
Random numbers: Project for: 3
1 3435
2 4234
3 4467
4 2321
5 1234 Then it will add, A1, A2, A(x), where x is 3

I hope I'm clear enough.
I will greatly appreciate your help.