Home
BetterSolutions.com
Online Documentation
Microsoft Office Excel
Microsoft Office Word
JavaScript Programming
VBA Programming
C# Programming
Microsoft Office Excel
Workbooks
Worksheets
Rows Columns
Cells Ranges
Data Validation
Data Analysis
Pivot Tables
Power Query
Search Excel ...
Functions
User Defined
Formulas
Dynamic Formulas
Reviewing
Track Changes
Named Ranges
Conditional Format
Microsoft Word
Tables
Charts
Dates Times
Formatting
Illustrations
Layout
Importing
XML
Microsoft PowerPoint
Ribbon
Options
Shortcut Keys
Protection
Add-ins
Macros
Templates
Quant Finance
Microsoft Outlook
Microsoft Office Excel
Worksheet Functions List
Ribbon Tabs Explained
Keyboard Shortcut Keys
Best Practices
Search Excel ...
VBA Programming
Visual Basic Editor
Best Practices
Macros
Syntax
Arrays
Collections
Error Handling
Debugging
Search VBA ...
Data Types
Variables
Strings
Numbers
Dates
Text Files
Directories
XML
Questions
Functions
Subroutines
MsgBox
InputBox
Userforms
Controls
Events
Databases
JS Programming
Ribbon
Options
Shortcut Keys
Enumerations
Class Modules
References
Web Services
SQL
C# Programming
VBA Programming
Complete Functions List
Recording Macros
Syntax And Loops
Best Practices
Search VBA ...
Bespoke Development
Office Add-in Development
JavaScript Office Add-ins
VSTO and C# Integration
Macros and VBA Programming
High Value Consultancy
Get In Touch
Excel
>
Formulas
Microsoft Excel
Formulas
ITEM
Counting
Complete List
Updated: 24 January 2023
24 January 2023
Count cells equal to 1 value case sensitive
=SUMPRODUCT((--EXACT(value, CellRange)))
© 2023 Better Solutions Limited.
All Rights Reserved.
© 2023
Better Solutions Limited
Top