I'm having a problem with formula's on Excel. I'm not too hot on it and I only know the basics..
I've created a spreadsheet for keeping track of company purchases, on the credit card, cash, cheque, paypal, etc.
I currently only have the knowledge on the SUM() formula, however I would like to calculate the total amount spent on each payment method (Chosen in the right-hand column).
Does anyone know how I can get this to work? :-)
see the link below on how to do it:
http://office.microsoft.com/en-us/excel-help/insert-subtotals-in-a-list-of-data-in-a-worksheet-HP010342620.aspx
Sincerely,
Ed