How to sum the credit card trasection by credit card type in excel.
Forum Thread: How to Sum the Credit Card in Excel by Credit Card Type.
- Hot
- Active
-
Forum Thread: How to Make a Simple Report Card Template in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Insert 'NESTED if' with Ease 0 Replies
6 yrs ago -
Forum Thread: How to Memorise the Excel Formula Syntax 0 Replies
6 yrs ago -
Forum Thread: How to Remove Line Breaks in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Speedometer Chart or Gauge Chart in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Add Dependent Data Validations in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Task Tracker in Excel 0 Replies
6 yrs ago -
Forum Thread: OneNote 2010 document 0 Replies
8 yrs ago -
Forum Thread: How to Turn Off Panning Hand 0 Replies
8 yrs ago -
Forum Thread: While in a Spread Sheet, I Click on One Cell and It Will Auto Highlight Many. Why and How Do I Undo It? 0 Replies
8 yrs ago -
Mail Merge Software: Hello. 0 Replies
8 yrs ago -
Forum Thread: PPTX File Is Giving an Error and Can't Be Opened. 2 Replies
8 yrs ago -
Forum Thread: How to Use Vlookup 0 Replies
8 yrs ago -
Forum Thread: Need Some Help with an Inventory Formula. (Purchase Date)(Sold Date)(Number of Days Held). However, if the Inventory Is 0 Replies
8 yrs ago -
Forum Thread: How to use AND, OR with the IF function 1 Replies
8 yrs ago -
Forum Thread: How to Create a Personal Finance Spreadsheet 0 Replies
8 yrs ago -
Forum Thread: How to Format a Chart Based on Another Chart Format 0 Replies
8 yrs ago -
Forum Thread: Powerpoint Presentation Design 0 Replies
8 yrs ago -
Forum Thread: How to Create Excel Based Interactive Awesome Histograms 0 Replies
8 yrs ago -
Forum Thread: Why Aren't TRUE Excel Based Dashboards More Prevalent? 0 Replies
8 yrs ago
-
How To: Generate random numbers (with decimals) in Excel
-
How To: Create a Basic Attendance Sheet in Excel
-
How To: Conditionally format at every change in value in Excel
-
How To: Create a table for the VLOOKUP function in Excel
-
How To: Create a Tangent Line with Excel
-
How To: Clear data & cell contents in Excel using a macro
-
How To: Create a sudoku puzzle in Excel with array formulas
-
How To: Do matrix multiplication and inverse in MS Excel
-
How To: Use the Excel Vlookup function in Microsoft Excel 2007
-
How To: Create a dynamic weekly chart in Microsoft Excel
-
How To: Multiply column times row with Transpose in MS Excel
-
How To: Format reports with the Layout view in MS Access 2010
-
How To: Create an in-cell dropdown menu in Excel 2003
-
How To: Use Excel for daily interest and monthly deposits
-
How To: Use the sparkline function in Microsoft Excel 2010
-
How To: Create a multiuser login system in Microsoft Access
-
How To: Create an interest-only loan schedule in Microsoft Excel
-
How To: Use borders in MS Word 2007
-
How To: Create horizontal subtotals for a data set in MS Excel
-
How To: Display trend arrows in a Microsoft Excel spreadsheet
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