Forum Thread: How to Sum the Credit Card in Excel by Credit Card Type.

How to Sum the Credit Card in Excel by Credit Card Type.

How to sum the credit card trasection by credit card type in excel.

1 Response

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.

=SUMIF(A1:A6,"AMEX",B1:B6)

Helpful? Here is a useful resource with some free Excel training manuals, have a look.
http://www.microsofttraining.net/excel-training-london.php#resources

Share Your Thoughts

  • Hot
  • Active