BetterSolutions.com
BetterSolutions.com
Resources
Microsoft Office Word
VBA Programming
C# Programming
JavaScript Programming
Addins
Office Add-ins for Excel
Office Add-ins for Word
Consultancy
Macros, Templates and EUDAs
Office JS Add-ins and Scripts
Support
Troubleshooting
Long Term Partner
Development
VSTO and .NET Integration
End User Programming
Training
Microsoft 365 Migration
Please Contact Us Today for a FREE Consultation
Excel
Add-ins
Best Practices
Cells Ranges
Charts
Conditional Format
Data Analysis
Data Validation
Dates Times
Search Excel ...
Functions
User Defined
Formulas
Formatting
Illustrations
Importing
Layout
Macros
Our Services ...
Named Ranges
Options
Pivot Tables
Power Query
Protection
Reviewing
Ribbon
Rows Columns
Find Add-ins ...
Shortcut Keys
Tables
Templates
Track Changes
Workbooks
Worksheets
XML
Finance / Quant
Contact Us ...
Word
Add-ins
Bookmarks
Building Blocks
Bullets
Characters
Charts
Content Controls
Design
Search Word ...
Documents
Fields
Illustrations
Importing
Layout
Macros
Mailings
Numbering
Our Services ...
Options
Outlines
Pages
Paragraphs
Protection
References
Reviewing
Ribbon
Find Add-ins ...
Sections
Shortcut Keys
Styles
Tables
Templates
Text Boxes
Track Changes
XML
Contact Us ...
PowerPoint
Add-ins
Animation
Bullets
Characters
Charts
Design
Handouts
Illustrations
Search PowerPoint ...
Importing
Layout
Macros
Notes
Numbering
Options
Outlines
Paragraphs
Our Services ...
Presentations
Protection
References
Reviewing
Ribbon
Sections
Shortcut Keys
Slide Show
Find Add-ins ...
Slides
Styles
Tables
Templates
Text Boxes
Track Changes
Transitions
Video
Contact Us ...
Outlook
Add-ins
Address Book
Alerts
Appointments
Calendar
Contacts
Events
Exchange
Search Outlook ...
Folders
Forms
Groups
HTML
Illustrations
Importing
Journal
Macros
Our Services ...
Mail
Meetings
Notes
OneDrive
OneNote
Options
People
Proofing
Find Add-ins ...
Ribbon
Rules
Search
SharePoint
Shortcut Keys
Tasks
Web Client
XML
Contact Us ...
VBA
Add-ins
Arrays
Best Practices
Class Modules
Code Snippets
Collections
Controls
Databases
Search VBA ...
Data Types
Dates Times
Debugging
Enumerations
Error Handling
Events
Files Directories
Functions
Our Services ...
Macros
MsgBox
Numbers
Options
References
Ribbon
Shortcut Keys
SQL
Find Add-ins ...
Strings
Subroutines
Syntax
Userforms
Variables
Visual Basic Editor
Web Interaction
XML
Contact Us ...
C#
.NET Library
Arrays
Best Practices
Classes
Collections
Databases
Data Types
Dates Times
Search C# ...
Debugging
Excel Interop
Error Handling
Files Directories
Generics
Interfaces
MessageBox
Numbers
Our Services ...
Projects
Serialization
Strings
Structures
Syntax
Threading
Variables
VBA Migration
Find Add-ins ...
Visual Studio
VSTO Add-ins
Web Add-ins
Web Development
Web Services
Windows Forms
WPF Forms
XML
Contact Us ...
JS
Arrays
Custom Functions
Data Types
Dates Times
Debugging
Dialog Boxes
Error Handling
Excel API
Search JavaScript ...
Express Backend
Fluent UI
Functions
HTML Pages
Microsoft Graph
Node JS Runtime
Numbers
Objects
Our Services ...
Office Add-ins
Office Events
Office Manifest
Office Scripts
Outlook API
PowerPoint API
React Library
Ribbon Commands
Find Add-ins ...
Strings
Syntax
Task Panes
TypeScript
Variables
Visual Studio Code
Word API
Yeoman Generator
Contact Us ...
Excel
>
Formulas
Microsoft Excel
Formulas
User FAQs ...
Shortcut Keys ...
Troubleshooting ...
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 October 2024
01 October 2024
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
© 2024 Better Solutions Limited.
All Rights Reserved.
© 2024
Better Solutions Limited
Top