Count

Excel Help for count in Analyzing Corporate Financial Data

Find Excel Solutions

Search the Forums:
	Search
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel

Follow Business Spreadsheets On:

Home > Forum Home > Analyzing Corporate Financial Data > count

Forum Topic

count

Rate this:

(3/5 from 1 vote)

	I 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 sunil on 31-Aug-2009

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Concatenate and COUNTIF 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 Excel Helper on 01-Sep-2009

Displaying page 1 of 1

Excel templates and solutions matched for count:
Products: Investment and Business Valuation | Portfolio Performance Monitoring | Asset Register | 5 Year Financial Plan | Financial Analysis Templates | Forecasting Tools Graph | 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 | Touring Merchandise Management | 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 | Cash Register | Invoice Creation | eBay Template | Inventory Accounting | Depreciation Schedules | Accounts Receivable Template | Financial Ratio Templates | Accounting Ledger
Categories: Business Finance | Business Valuation | Financial Accounting

Find Excel templates
and add-ins in the
Excel Business Solutions Directory

© 2013 Business Spreadsheets. All Rights Reserved. Legal | About Us