HomeBetterSolutions.com
  • Online Documentation
    Microsoft Office ExcelMicrosoft Office WordJavaScript ProgrammingVBA ProgrammingC# 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 ListRibbon Tabs ExplainedKeyboard Shortcut KeysBest PracticesSearch 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 ListRecording MacrosSyntax And LoopsBest PracticesSearch VBA ...
  • Bespoke Development
    Office Add-in DevelopmentJavaScript Office Add-insVSTO and C# IntegrationMacros and VBA ProgrammingHigh Value Consultancy
  • Get In Touch
Excel > Formulas

  • Microsoft Excel
  • Formulas
  • User FAQs ...
  • Shortcut Keys ...
  • Troubleshooting ...
  • Different Error Types ...
  • Complete List
  • Categories ...
  • Counting Formulas
  • Summing Formulas
  • Lookup Formulas
  • Inserting ...
  • Calculation ...
  • Auditing ...
  • Error Checking ...
  • Dynamic Formulas ...
  • Array Formulas ...
  • Updates ...
  • Code - TypeScript
  • Code - VBA ...
  • Updated: 01 February 2023
  • 01 February 2023

Counting Formulas

This is our list of the most frequently asked formulas that involve counting.


Numbers

Count cells that are numbers in a range
Count cells that are numbers and either x or y
Count cells that are numbers and greater than a value
Count cells that are numbers and unique
Count cells that are not numbers


Dates

Count cells that are dates between 2 dates
Count cells that are dates and either x or y
Count cells that are dates and in a particular year
Count cells that are dates and not between 2 dates
Count cells that are not dates


Text

Count cells that are text
Count cells that are text and begin with
Count cells that are text and contain specific text case sensitive
Count cells that are text and end with
Count cells that are text and equal to a value case sensitive
Count cells that are text and unique
Count cells that are not text


Blank, Errors, Hidden

Count cells that are blank
Count cells that are errors
Count cells that are hidden
Count cells that are visible


© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext