Help me with Excel! Formula problems!

[RMSistight]

I'm trying to reference the same cell on every line.

So here is the example:

sum(c8:c1)
sum(c8:c2)
sum(c8:c3)

and so on and so on.

I want the c8 part to stay the same while the c1, c2 keeps on going up by one. How do I do this?

 

[DurocShark]

Wow, it's been a long time since I did any serious work in Excel... But I seem to recall there's an inc+1 or something similar? Bah, I'm no help. Sorry.

 

[Joker81]

USE SUM(C$8,c1)

 

[Digobick]

Actually I would use the dollar sign before the 'C' as well:

SUM($C$8:C1)
SUM($C$8:C2)
SUM($C$8:C3)

so that it would lock in both the column and the row of that cell.