hi folks
I'm trying to create an invoice document for work, and I need the assistance of someone with some formula skills...
Basically there's four columns in the invoice spreadsheet: Item Description, Unit Cost, Quantity & Sub-Total.
At the bottom of the sub-total column there are three boxes; net-total, VAT & TOTAL. I want to preserve this layout.
What I am trying to do is write formulae for the net-total, VAT & TOTAL boxes that do not break when you add or remove rows; I want the spreadsheet to be able to work regardless of how many items (one to a row) are being invoiced.
Column D is the sub-total column, so presumably for the Net Total Box the formula should be something like SUM(D2 : DX) where X=The-box-above-this-one, but I don't know the correct notation for this in Excel...
If I could just get that manner of cell reference sorted I could adapt it for the two further boxes below; VAT & TOTAL
Well I hope that makes sense enough for someone to be able to give me some advice
This may not even be possible, I've looked at a lot of Invoice Templates on the MS Office website, and none of them have 'smart' summing formulae like this, they are all based on specific cell references: i.e. Sum(D2 : D9)
Cheers,
gooner
I'm trying to create an invoice document for work, and I need the assistance of someone with some formula skills...
Basically there's four columns in the invoice spreadsheet: Item Description, Unit Cost, Quantity & Sub-Total.
At the bottom of the sub-total column there are three boxes; net-total, VAT & TOTAL. I want to preserve this layout.
What I am trying to do is write formulae for the net-total, VAT & TOTAL boxes that do not break when you add or remove rows; I want the spreadsheet to be able to work regardless of how many items (one to a row) are being invoiced.
Column D is the sub-total column, so presumably for the Net Total Box the formula should be something like SUM(D2 : DX) where X=The-box-above-this-one, but I don't know the correct notation for this in Excel...
If I could just get that manner of cell reference sorted I could adapt it for the two further boxes below; VAT & TOTAL
Well I hope that makes sense enough for someone to be able to give me some advice
This may not even be possible, I've looked at a lot of Invoice Templates on the MS Office website, and none of them have 'smart' summing formulae like this, they are all based on specific cell references: i.e. Sum(D2 : D9)
Cheers,
gooner