• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Help me with Excel! Formula problems!

R

RMSistight

Golden Member
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?
 
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.
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top