Home > Forum Home > Analyzing Corporate Financial Data > count Share

Count

Excel Help for Count in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Count

Rate this:
(3/5 from 1 vote)
ConfusedI have searched the discussion group for answers, but none exactly match my
question.  I have two columns, and I need to count how many times a certain
"match" occurs.  E.g., here's the data:

         A                 B
1  Abbott         Knee replacement
2  Costello       Knee replacement
3  Costello       Shoulder replacement
4  Costello       Shoulder replacement
5  Abbott         Knee replacement

I need to count how many times Dr. Abbott did a knee replacement, how many
times Dr. Costello did a knee replacement, etc.  Each query will reside in
its own cell, so I need a formula for each query.  In the above example, I
would have four different cells containing the COUNT function/formula, e.g.,
one cell will be labeled "Abbott - Knee replacements", another will be
"Costello -- Knee replacements", another will be "Abbott -- shoulder
replacements", another will be "Costello -- shoulder replacements".
 huria
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Shocked
Rate this:
(3/5 from 1 vote)
You should concatenate the two columns with doctor name and operation first in column C.  To split out the number from the doctor name, you might want to use a string function like =RIGHT(cell, LEN(cell)-2).  If the numbers go over 1 character in length you will need to replace the LEN part with a FIND function for the space character after the number.

After that you can used the COUNTIF function on the range of concatenations to return the number of unique doctor/operation pairs.

 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for count:

Solutions: Investment and Business Valuation Portfolio Performance Monitoring Asset Register 5 Year Financial Plan Financial Analysis Templates Inventory Management Cash Flow Valuation Productivity Add-ins Equity Valuation Model Financial Accounting Projections Profit and Loss Report Import MYOB Data Financial Formula Calculations Bank Account Reconciliation Finance Templates and Calculators Financial Reporting General Ledger Lease and Loan Calculation Consolidate Spreadsheets 10 Year Financial Statements Planning Expense Claim Form Accounting Templates Cash Flow Analysis Invoice Creation eBay Template Inventory Accounting Depreciation Schedules Accounts Receivable Template Financial Ratio Templates Economic Data Tools Add-ins
Categories: Business Finance Business Valuation Financial Accounting