Hi,

How do I make a formula work for an entire column without having to input
each row, one at a time? Each cell in the column would be calculating from
another columns entry. I currently am inputting it like this.....

D1: =SUM(C1)-1
D2: =SUM(C2)-1
D3: =SUM(C3)-1

Is there a way for me to set the formula for the entire column eventhough it
has to reference a new cell from another column each time (as in the example
above)?

Any help would be greatly appreciated!!! =)