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.

Life Hacks for Your Smartphone

Fresh tips every day.

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