Adding Filtered Values

[trolley]

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.

 

[inarbeth]

Hello trolley.
Have you tried the SUBTOTAL function - it's ideal for adding up filtered lists. Have a look at the help file in Excel.