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