Home
BetterSolutions.com
Online Documentation
Microsoft Office Excel
Microsoft Office Word
VBA Programming
C# Programming
JavaScript Programming
Microsoft Office Excel
Workbooks
Worksheets
Rows Columns
Cells Ranges
Data Validation
Data Analysis
Pivot Tables
Power Query
Search Excel ...
Functions
User Defined
Formulas
Array Formulas
Reviewing
Track Changes
Named Ranges
Conditional Format
Microsoft Word
Tables
Charts
Dates Times
Formatting
Illustrations
Page 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
Quantitative Finance
Search Excel ...
VBA Programming
Code 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
Controls
Userforms
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 ...
Conditional
Counting
Data Validation
Date & Time
Filtering
Formatting
Lookup
Number
Summing
Text
Other
Inserting ...
Calculation ...
Error Checking ...
Debugging ...
Array Formulas ...
Dynamic Array Formulas
Updates ...
VBA Code ...
Updated: 05 January 2021
05 January 2021
Counting Formulas
Count cells between 2 dates
Counting - Between
Count cells between 2 numbers
Counting - Between
Count cells equal to 1 value
Counting - Equal To
Count cells equal to 1 value case sensitive
Counting - Equal To
Count cells equal to 2 values
Counting - Equal To
Count cells equal to 3 or more values
Counting - Equal To
Count cells equal to either x or y
Counting - Equal To
Count cells equal to one of many
Counting - Equal To
Count cells greater than 1 value
Counting - Less Than or Greater Than
Count cells less than 1 value
Counting - Less Than or Greater Than
Count cells not equal to 1 value
Counting - Not Equal To
Count cells not equal to 1 value case sensitive
Counting - Not Equal To
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 either x or y
Counting - Not Equal To
Count cells that are a number of characters long
Counting - Contain
Count cells that are blank
Counting - Equal To
Count cells that are errors
Counting - Contain
Count cells that are even numbers
Counting - Contain
Count cells that are negative numbers
Counting - Contain
Count cells that are not blank
Counting - Not Equal To
Count cells that are not equal to either x or y
Counting - Are
Count cells that are not equal to one of many
Counting - Are
Count cells that are not errors
Counting - Not Equal To
Count cells that are not text
Counting - Not Equal To
Count cells that are numbers
Counting - Are
Count cells that are odd numbers
Counting - Are
Count cells that are positive numbers
Counting - Are
Count cells that are text
Counting - Are
Count cells that are unique numbers
Counting - Are
Count cells that are unique text strings
Counting - Are
Count cells that are unique text strings with 1 condition
Counting - Are
Count cells that begin with
Counting - Contain
Count cells that contain 1 text string
Counting - Contain
Count cells that contain 2 text strings
Counting - Contain
Count cells that contain dates between 2 dates
Counting - Contain
Count cells that contain either x or y
Counting - Contain
Count cells that contain errors
Counting - Contain
Count cells that contain even numbers
Counting - Contain
Count cells that contain n characters
Counting - Contain
Count cells that contain negative numbers
Counting - Contain
Count cells that contain numbers
Counting - Contain
Count cells that contain numbers between 2 numbers
Counting - Contain
Count cells that contain numbers greater than a value
Counting - Contain
Count cells that contain numbers less than a value
Counting - Contain
Count cells that contain numbers with 1 condition
Counting - Conditional
Count cells that contain numbers with multiple conditions
Counting - Conditional
Count cells that contain odd numbers
Counting - Contain
Count cells that contain positive numbers
Counting - Contain
Count cells that contain text
Counting - Contain
Count cells that contain text of a certain length
Counting - Contain
Count cells that contain unique dates
Counting - Contain
Count cells that contain unique numbers
Counting - Contain
Count cells that contain unique numbers with 1 condition
Counting - Conditional
Count cells that contain unique text strings
Counting - Contain
Count cells that contain unique text strings with 1 condition
Counting - Conditional
Count cells that contain unique values
Counting - Contain
Count cells that do not begin with
Counting - Contain
Count cells that do not contain a text string
Counting - Contain
Count cells that do not contain any errors
Counting - Contain
Count cells that do not contain any numbers
Counting - Contain
Count cells that do not contain any numbers or text
Counting - Contain
Count cells that do not end with
Counting - Contain
Count cells that end with
Counting - Contain
Count cells that meet either condition
Counting - Conditional
Count cells with formatting
Counting - Conditional
Count cells with shading
Counting - Conditional
Count columns with multiple OR criteria
Counting - Other
Count differences between 2 cell ranges
Counting - Conditional
Count hidden rows
Counting - Other
Count hidden rows in a filtered column
Counting - Other
Count hidden rows with 1 condition
Counting - Other
Count hidden rows with multiple conditions
Counting - Other
Count if items are in a list
Counting - Other
Count if row meets internal criteria
Counting - Other
Count if row meets multiple internal criteria
Counting - Other
Count if two criteria match
Counting - Other
Count matches between 2 columns
Counting - Other
Count rows with multiple OR criteria
Counting - Other
Count substring occurrences
Counting - Other
Count total characters in range
Counting - Other
Count total matches in 2 ranges
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 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 cells between 2 dates
Counting - Between
Count cells between 2 numbers
Counting - Between
Count cells equal to 1 value
Counting - Equal To
Count cells equal to 1 value case sensitive
Counting - Equal To
Count cells equal to 2 values
Counting - Equal To
Count cells equal to 3 or more values
Counting - Equal To
Count cells equal to either x or y
Counting - Equal To
Count cells equal to one of many
Counting - Equal To
Count cells greater than 1 value
Counting - Less Than or Greater Than
Count cells less than 1 value
Counting - Less Than or Greater Than
Count cells not equal to 1 value
Counting - Not Equal To
Count cells not equal to 1 value case sensitive
Counting - Not Equal To
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 either x or y
Counting - Not Equal To
Count cells that are a number of characters long
Counting - Contain
Count cells that are blank
Counting - Equal To
Count cells that are errors
Counting - Contain
Count cells that are even numbers
Counting - Contain
Count cells that are negative numbers
Counting - Contain
Count cells that are not blank
Counting - Not Equal To
Count cells that are not equal to either x or y
Counting - Are
Count cells that are not equal to one of many
Counting - Are
Count cells that are not errors
Counting - Not Equal To
Count cells that are not text
Counting - Not Equal To
Count cells that are numbers
Counting - Are
Count cells that are odd numbers
Counting - Are
Count cells that are positive numbers
Counting - Are
Count cells that are text
Counting - Are
Count cells that are unique numbers
Counting - Are
Count cells that are unique text strings
Counting - Are
Count cells that are unique text strings with 1 condition
Counting - Are
Count cells that begin with
Counting - Contain
Count cells that contain 1 text string
Counting - Contain
Count cells that contain 2 text strings
Counting - Contain
Count cells that contain dates between 2 dates
Counting - Contain
Count cells that contain either x or y
Counting - Contain
Count cells that contain errors
Counting - Contain
Count cells that contain even numbers
Counting - Contain
Count cells that contain n characters
Counting - Contain
Count cells that contain negative numbers
Counting - Contain
Count cells that contain numbers
Counting - Contain
Count cells that contain numbers between 2 numbers
Counting - Contain
Count cells that contain numbers greater than a value
Counting - Contain
Count cells that contain numbers less than a value
Counting - Contain
Count cells that contain numbers with 1 condition
Counting - Conditional
Count cells that contain numbers with multiple conditions
Counting - Conditional
Count cells that contain odd numbers
Counting - Contain
Count cells that contain positive numbers
Counting - Contain
Count cells that contain text
Counting - Contain
Count cells that contain text of a certain length
Counting - Contain
Count cells that contain unique dates
Counting - Contain
Count cells that contain unique numbers
Counting - Contain
Count cells that contain unique numbers with 1 condition
Counting - Conditional
Count cells that contain unique text strings
Counting - Contain
Count cells that contain unique text strings with 1 condition
Counting - Conditional
Count cells that contain unique values
Counting - Contain
Count cells that do not begin with
Counting - Contain
Count cells that do not contain a text string
Counting - Contain
Count cells that do not contain any errors
Counting - Contain
Count cells that do not contain any numbers
Counting - Contain
Count cells that do not contain any numbers or text
Counting - Contain
Count cells that do not end with
Counting - Contain
Count cells that end with
Counting - Contain
Count cells that meet either condition
Counting - Conditional
Count cells with formatting
Counting - Conditional
Count cells with shading
Counting - Conditional
Count columns with multiple OR criteria
Counting - Other
Count differences between 2 cell ranges
Counting - Conditional
Count hidden rows
Counting - Other
Count hidden rows in a filtered column
Counting - Other
Count hidden rows with 1 condition
Counting - Other
Count hidden rows with multiple conditions
Counting - Other
Count if items are in a list
Counting - Other
Count if row meets internal criteria
Counting - Other
Count if row meets multiple internal criteria
Counting - Other
Count if two criteria match
Counting - Other
Count matches between 2 columns
Counting - Other
Count rows with multiple OR criteria
Counting - Other
Count substring occurrences
Counting - Other
Count total characters in range
Counting - Other
Count total matches in 2 ranges
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 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
© 2021 Better Solutions Limited.
All Rights Reserved.
© 2021
Better Solutions Limited
Top