How to sum the credit card trasection by credit card type in excel.
Start by having your Credit Cards listed in a column next to your Credit Card Values
Use the SUMIF function to Match the Credit Card word e.g "AMEX" against the Credit Card Names in A1:A6.
B1:B6 could be the values. Anytime the word "Amex" appears in the Range A1:A6 it will pull out the figures in Column B.
Helpful? Here is a useful resource with some free Excel training manuals, have a look.http://www.microsofttraining.net/excel-training-london.php#resources