TrimPath Forum
About TrimPath stuff, like Junction, Next Action, JavaScript Templates, TrimQuery, TrimSpreadsheet, etc...
You are not logged in.
#1 2005-10-30 20:27:13
- herod2221
- New member
- Registered: 2005-10-30
- Posts: 2
extending formula down entire column/row
i'm creating a spreadsheet to track finances, and want to basically have a sum function that goes down an entire column. so i can add a new transaction and it would automatically subtract that amount from the balance. it seems that currently i need to add the formula for every cell - can i set a formula for the whole column?
Offline
#2 2005-11-01 22:49:23
Re: extending formula down entire column/row
Yeah, right now it's limited to setting a formula for every cell. Setting a formula for the whole column makes sense. There's lots of Excel 12 functionality like that which we're looking at closely.
Offline
#3 2005-11-02 11:52:16
- cbit
- New member
- Registered: 2005-11-02
- Posts: 1
Re: extending formula down entire column/row
sorry if this sounds daft, but does this mean that currently, to calculate the sum of a colum you'de have to enter something like this into a cell? "=SUM(A1:A2:A3:A4:A5:A6:A7:A8)" (i think im missing something 
)
thanks (spreadsheet n00b)
Offline
#4 2005-11-02 17:03:02
Re: extending formula down entire column/row
nope, you just do "=SUM(A1:A18)", where A18 is the last cell in column A.
I was thinking the original post wanted something like "=SUM(ENTIRE_COLUMN(A))", so that when you add or remove rows, the formula would still work without having to touch it.
Offline
#5 2005-12-13 18:35:27
- gebennett
- New member
- Registered: 2005-12-13
- Posts: 1
Re: extending formula down entire column/row
In Excel I would usually use =SUM(A:A) to reference the entire column.
Offline