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
7 yrs ago -
Forum Thread:
How to Insert 'NESTED if' with Ease
0
Replies
7 yrs ago -
Forum Thread:
How to Memorise the Excel Formula Syntax
0
Replies
7 yrs ago -
Forum Thread:
How to Remove Line Breaks in Excel
0
Replies
7 yrs ago -
Forum Thread:
How to Create a Speedometer Chart or Gauge Chart in Excel
0
Replies
7 yrs ago -
Forum Thread:
How to Add Dependent Data Validations in Excel
0
Replies
7 yrs ago -
Forum Thread:
How to Create a Task Tracker in Excel
0
Replies
7 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
9 yrs ago -
Mail Merge Software:
Hello.
0
Replies
9 yrs ago -
Forum Thread:
PPTX File Is Giving an Error and Can't Be Opened.
2
Replies
9 yrs ago -
Forum Thread:
How to Use Vlookup
0
Replies
9 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
9 yrs ago -
Forum Thread:
How to use AND, OR with the IF function
1
Replies
9 yrs ago -
Forum Thread:
How to Create a Personal Finance Spreadsheet
0
Replies
9 yrs ago -
Forum Thread:
How to Format a Chart Based on Another Chart Format
0
Replies
9 yrs ago -
Forum Thread:
Powerpoint Presentation Design
0
Replies
9 yrs ago -
Forum Thread:
How to Create Excel Based Interactive Awesome Histograms
0
Replies
9 yrs ago -
Forum Thread:
Why Aren't TRUE Excel Based Dashboards More Prevalent?
0
Replies
9 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:
Clear data & cell contents in Excel using a macro
-
How To:
Do matrix multiplication and inverse in MS Excel
-
How To:
Create a multiuser login system in Microsoft Access
-
How To:
Hide scroll bars, sheet tabs & charts in Excel
-
How To:
Create a Tangent Line with Excel
-
How To:
Calculate YTM and effective annual yield from bond cash flows in Excel
-
How To:
Pull data from one Excel worksheet to another via DGET
-
How To:
Convert written math statements into Excel equations
-
How To:
Create a sudoku puzzle in Excel with array formulas
-
How To:
Generate a dynamic list from a table in MS Excel
-
How To:
Navigate & use the Query by Example (QBE) interface in Microsoft Access 2007
-
How To:
Remove spaces from numbers in Excel with the SUBSTITUTE function
-
How To:
Calculate a bonus in Microsoft Excel
-
How To:
Make calculations for markup & markdown in Excel
-
How To:
Cross tabulate categorical data in Microsoft Excel
-
How To:
Chart cross-sectional and time series data in MS Excel
-
How To:
Find the diagonal sum 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