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
C# Programming
Ribbon
Options
Shortcut Keys
Enumerations
Class Modules
References
Web Services
SQL
JS 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
User FAQs ...
Shortcut Keys ...
Troubleshooting ...
Different Error Types ...
Complete List
Categories ...
Counting
Summing
Lookup
Conditional
Date & Time
Formatting
Number
Statistical
Text
Filtering
Data Validation
Other
Counting Formulas
Summing Formulas
Lookup Formulas
Inserting ...
Calculation ...
Auditing ...
Error Checking ...
Dynamic Formulas ...
Array Formulas ...
Updates ...
Code - TypeScript
Code - VBA ...
Updated: 01 September 2023
01 September 2023
Counting Formulas
Count cells equal to 2 values
Counting - Equal To
Count cells equal to 3 or more values
Counting - Equal To
Count cells equal to one of many
Counting - Equal To
Count cells equal to this or that
Counting - Equal To
Count cells in a table when a column is greater than a value
Counting - Table
Count cells in a table when a column is less than a value
Counting - Table
Count cells in a table when a column is unique with 1 condition
Counting - Are
Count cells in a table when a column meets 1 condition
Counting - Table
Count cells in a table when a column meets multiple conditions
Counting - Table
Count cells not equal to 2 values
Counting - Not Equal To
Count cells not equal to 3 or more values
Counting - Not Equal To
Count cells not equal to a value
Counting - Not Equal To
Count cells not equal to one of many
Counting - Not Equal To
Count cells that are blank
Counting - Equal To
Count cells that are dates
Counting - Equal To
Count cells that are dates and either x or y
Counting - Contain
Count cells that are dates and equal to a value
Counting - Contain
Count cells that are dates and in a particular month
Counting - Contain
Count cells that are dates and in a particular year
Counting - Contain
Count cells that are dates and not between 2 dates
Counting - Contain
Count cells that are dates and not equal to a value
Counting - Contain
Count cells that are dates and unique
Counting - Contain
Count cells that are dates between 2 dates
Counting - Contain
Count cells that are dates by day of week
Counting - Other
Count cells that are errors
Counting - Contain
Count cells that are hidden
Counting - Other
Count cells that are not blank
Counting - Not Equal To
Count cells that are not dates
Counting - Not Equal To
Count cells that are not errors
Counting - Not Equal To
Count cells that are not hidden
Counting - Not Equal To
Count cells that are not numbers
Counting - Contain
Count cells that are not text
Counting - Not Equal To
Count cells that are not text or numbers
Counting - Contain
Count cells that are numbers
Counting - Contain
Count cells that are numbers and do not equal a value
Counting - Contain
Count cells that are numbers and do not equal either x or y
Counting - Contain
Count cells that are numbers and either x or y
Counting - Contain
Count cells that are numbers and equal to a value
Counting - Contain
Count cells that are numbers and even
Counting - Contain
Count cells that are numbers and greater than a value
Counting - Contain
Count cells that are numbers and less than a value
Counting - Contain
Count cells that are numbers and negative
Counting - Contain
Count cells that are numbers and odd
Counting - Are
Count cells that are numbers and positive
Counting - Contain
Count cells that are numbers and unique
Counting - Are
Count cells that are numbers in a range
Counting - Other
Count cells that are numbers with leading zeros
Counting - Other
Count cells that are text
Counting - Are
Count cells that are text and begin with
Counting - Contain
Count cells that are text and contain either x or y
Counting - Contain
Count cells that are text and contain a value
Counting - Other
Count cells that are text and contain a value case sensitive
Counting - Other
Count cells that are text and do not begin with
Counting - Contain
Count cells that are text and do not contain a value
Counting - Other
Count cells that are text and do not equal a value
Counting - Other
Count cells that are text and do not equal either x or y
Counting - Other
Count cells that are text and do not end with
Counting - Contain
Count cells that are text and either x or y
Counting - Other
Count cells that are text and end with
Counting - Other
Count cells that are text and equal to a value
Counting - Contain
Count cells that are text and equal to a value case sensitive
Counting - Contain
Count cells that are text and n characters long
Counting - Contain
Count cells that are text and over n characters long
Counting - Other
Count cells that are text and unique
Counting - Are
Count cells that are visible
Counting - Other
Count cells with formatting
Counting - Conditional
Count cells with shading
Counting - Conditional
Count differences between 2 cell ranges
Counting - Conditional
Count occurrences in entire workbook
Counting - Other
Count or sum variance
Counting - Other
Count substring occurrences
Counting - Other
Count times in a particular range
Counting - Other
Count total characters in range
Counting - Other
Count total matches in 2 ranges
Counting - Other
Count unique dates
Counting - Other
Count unique numbers
Counting - Other
Count unique numbers with 1 condition
Counting - Other
Count unique text strings
Counting - Other
Count unique text strings with 1 condition
Counting - Other
Count unique values
Counting - Other
Count visible cells
Counting - Other
Count visible columns
Counting - Other
Count visible rows
Counting - Other
Count visible rows in a filtered column
Counting - Other
Count visible rows with 1 condition
Counting - Other
Count visible rows with multiple conditions
Counting - Other
Count whole numbers only
Counting - Other
Count cells equal to 2 values
Counting - Equal To
Count cells equal to 3 or more values
Counting - Equal To
Count cells equal to one of many
Counting - Equal To
Count cells equal to this or that
Counting - Equal To
Count cells in a table when a column is greater than a value
Counting - Table
Count cells in a table when a column is less than a value
Counting - Table
Count cells in a table when a column is unique with 1 condition
Counting - Are
Count cells in a table when a column meets 1 condition
Counting - Table
Count cells in a table when a column meets multiple conditions
Counting - Table
Count cells not equal to 2 values
Counting - Not Equal To
Count cells not equal to 3 or more values
Counting - Not Equal To
Count cells not equal to a value
Counting - Not Equal To
Count cells not equal to one of many
Counting - Not Equal To
Count cells that are blank
Counting - Equal To
Count cells that are dates
Counting - Equal To
Count cells that are dates and either x or y
Counting - Contain
Count cells that are dates and equal to a value
Counting - Contain
Count cells that are dates and in a particular month
Counting - Contain
Count cells that are dates and in a particular year
Counting - Contain
Count cells that are dates and not between 2 dates
Counting - Contain
Count cells that are dates and not equal to a value
Counting - Contain
Count cells that are dates and unique
Counting - Contain
Count cells that are dates between 2 dates
Counting - Contain
Count cells that are dates by day of week
Counting - Other
Count cells that are errors
Counting - Contain
Count cells that are hidden
Counting - Other
Count cells that are not blank
Counting - Not Equal To
Count cells that are not dates
Counting - Not Equal To
Count cells that are not errors
Counting - Not Equal To
Count cells that are not hidden
Counting - Not Equal To
Count cells that are not numbers
Counting - Contain
Count cells that are not text
Counting - Not Equal To
Count cells that are not text or numbers
Counting - Contain
Count cells that are numbers
Counting - Contain
Count cells that are numbers and do not equal a value
Counting - Contain
Count cells that are numbers and do not equal either x or y
Counting - Contain
Count cells that are numbers and either x or y
Counting - Contain
Count cells that are numbers and equal to a value
Counting - Contain
Count cells that are numbers and even
Counting - Contain
Count cells that are numbers and greater than a value
Counting - Contain
Count cells that are numbers and less than a value
Counting - Contain
Count cells that are numbers and negative
Counting - Contain
Count cells that are numbers and odd
Counting - Are
Count cells that are numbers and positive
Counting - Contain
Count cells that are numbers and unique
Counting - Are
Count cells that are numbers in a range
Counting - Other
Count cells that are numbers with leading zeros
Counting - Other
Count cells that are text
Counting - Are
Count cells that are text and begin with
Counting - Contain
Count cells that are text and contain either x or y
Counting - Contain
Count cells that are text and contain a value
Counting - Other
Count cells that are text and contain a value case sensitive
Counting - Other
Count cells that are text and do not begin with
Counting - Contain
Count cells that are text and do not contain a value
Counting - Other
Count cells that are text and do not equal a value
Counting - Other
Count cells that are text and do not equal either x or y
Counting - Other
Count cells that are text and do not end with
Counting - Contain
Count cells that are text and either x or y
Counting - Other
Count cells that are text and end with
Counting - Other
Count cells that are text and equal to a value
Counting - Contain
Count cells that are text and equal to a value case sensitive
Counting - Contain
Count cells that are text and n characters long
Counting - Contain
Count cells that are text and over n characters long
Counting - Other
Count cells that are text and unique
Counting - Are
Count cells that are visible
Counting - Other
Count cells with formatting
Counting - Conditional
Count cells with shading
Counting - Conditional
Count differences between 2 cell ranges
Counting - Conditional
Count occurrences in entire workbook
Counting - Other
Count or sum variance
Counting - Other
Count substring occurrences
Counting - Other
Count times in a particular range
Counting - Other
Count total characters in range
Counting - Other
Count total matches in 2 ranges
Counting - Other
Count unique dates
Counting - Other
Count unique numbers
Counting - Other
Count unique numbers with 1 condition
Counting - Other
Count unique text strings
Counting - Other
Count unique text strings with 1 condition
Counting - Other
Count unique values
Counting - Other
Count visible cells
Counting - Other
Count visible columns
Counting - Other
Count visible rows
Counting - Other
Count visible rows in a filtered column
Counting - Other
Count visible rows with 1 condition
Counting - Other
Count visible rows with multiple conditions
Counting - Other
Count whole numbers only
Counting - Other
© 2023 Better Solutions Limited.
All Rights Reserved.
© 2023
Better Solutions Limited
Top