I've made a spead sheet to sort out my friends accounts. It's quite a simple spreadsheet.
I've got to sort out cash(cc), cheque(chq), and transfers(trns).
I've got 6 columns : Date, Company, Total, Net, Vat, Type (cc)(chq)(trns).
I need to add the total spent using CC and total spent on CHQ and total spent on TRNS.
I can easily filter the different types, but I cant figure out how to give grand total for : total, Net, and VAT.
Basically he needs to find out how much is spent on CC, CHQ, and VAT.
If this sounds a bit long winded, I can email the speadsheet on demand to make it easier to understand.
I've got to sort out cash(cc), cheque(chq), and transfers(trns).
I've got 6 columns : Date, Company, Total, Net, Vat, Type (cc)(chq)(trns).
I need to add the total spent using CC and total spent on CHQ and total spent on TRNS.
I can easily filter the different types, but I cant figure out how to give grand total for : total, Net, and VAT.
Basically he needs to find out how much is spent on CC, CHQ, and VAT.
If this sounds a bit long winded, I can email the speadsheet on demand to make it easier to understand.