Forum Thread: 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.


Helpful? Here is a useful resource with some free Excel training manuals, have a look.

Share Your Thoughts

  • Hot
  • Active