» Counting number of unique entries in a specified range.
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
By using SUMPRODUCT along with COUNT to count only the number
of unique entries in a specified range.
The range can be all in one column or row, or may span multiple (adjoining) columns/rows.
The formula would be written as: =SUMPRODUCT((1/COUNTIF(A1:C5,A1:C5&"")))
where A1:C5 is replaced with the range you want to apply the count to.

Book Store:
Recommended Books:
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- How to Read A Financial Report
- The Fall of Advertising and the Rise of PR
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
No comments have been submitted.

