• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Excel

          • Excel Functions
          • Excel Tools
          • Excel Tips
        • Excel
        • Financial Functions Excel

          • NPV in Excel
          • IRR in excel
          • PV in Excel
        • Financial-Functions-Excel
        • Lookup Functions Excel

          • VLOOKUP
          • HLOOKUP
          • Index Function
        • Lookup-Functions-in-Excel
        • Excel Charts

          • Pareto Chart in Excel
          • Gannt Chart in Excel
          • Waterfall Chart in Excel
        • Excel-Charts
        • VBA

          • VBA Left Function
          • VBA Paste Special
          • VBA Worksheet Function
        • VBA
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Equity Research
          • Private Equity
          • Corporate Finance
          • Financial Statement Analysis
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course certificate
        • Excel VBA All in One Bundle

          Excel-VBA-Certification-Course
        • Excel Data Analysis Course

          Excel-Data-Analysis-Course
        • VBA Macros Course

          VBA-Training-Course
        • Others

          • Basic Excel Training
          • Advanced Excel Course
          • Tableau Certification Course
          • Excel for Finance Course

          • Excel for Marketers Course
          • Excel for HR Managers
          • Excel for Power Users
          • View All
  • Excel VBA All in One Bundle
  • Login

COUNT Function in Excel

Home » Excel » Statistical Functions in Excel » COUNT Function in Excel

By Roshan Waingankar Leave a Comment

COUNT Function in Excel

COUNT Function in Excel (Table of Contents)

  • COUNT Function in Excel
  • COUNT Formula in Excel
  • How to Use the COUNT Function?

COUNT Function in Excel

The COUNT function in Excel is a statistical function which is used to count the number of cells containing numbers within the given range. COUNT in Excel returns an integer number.

COUNT Formula in Excel

The COUNT formula in excel is as follows:

COUNT Formula

The COUNT Formula in Excel has two arguments out of which one is required. Where,

  • Value1 = It is a required parameter. This represents the starting date. The date must be entered by using the DATE Excel function. E.g.: DATE (2018,5,15)
  • Value n = It is an optional parameter and can range up to 255 values. The value can be a cell reference or a range of values i.e. a collection of worksheet cells containing a variety of data out of which only the cells containing numbers would be counted.

The return value of the COUNT formula in excel is a positive number. The value can be zero or non-zero.

How to Use COUNT Function in Excel?

This is a Worksheet (WS) function. As a WS function, COUNT in Excel can be entered as a part of the formula in a cell of a worksheet. Refer to the COUNT Function examples given below to understand better.

You can download this COUNT Function Excel Template here – COUNT Function Excel Template

COUNT Function in Worksheet

Let’s look at the COUNT Function examples given below. Each example covers a different use case implemented using COUNT function.

Example #1 – Count Numbers in the Given Range

COUNT (B3:B8)

COUNT Example 1

As shown in the above COUNT formula, the COUNT function is applied on the range B3:B8. The range contains only 3 numbers and hence the result returned by the COUNT function is 3 and the same is displayed in the resulting cell i.e. B10. Refer to the screenshot given below for the above-explained example.

Example #2 – Numbers in Double Quotes

 COUNTA (“1”,”2”)

COUNT Example 2

As shown in the above COUNT formula in excel, COUNTA function is applied to the value list separated by a comma. The values are “1”,”2”.  COUNTA function is used capable of processing such values and hence the results returned and contained by the result cell B11 is 2. Refer to the screenshot given below for the above-explained scenario.

Example #3 – Count the Number of Valid Dates

COUNT (C3:C8)

COUNT Example 3

As shown in the above Excel COUNT formula, the COUNT function is applied to the range of values C3:C8. The range contains dates represented using different formats out of which only 2 are written in a valid format. Hence, the result returned by the COUNT function is 2. The same is in the results cell i.e. C10. Refer to the screenshot given below for the above-explained example.

Example #4 – Multiple Parameters

COUNT (C3:C8,5)

COUNT Example 4

As shown in the above Excel COUNT formula, COUNT function is applied on the range of values C3:C8 and another parameter is hard-coded with value 5. So, the result returned is the total number of valid numbers present in the range and the number 5.  Refer to the screenshot given below for the above explained example.

Example #5 – Zero Valid Numbers

COUNT (C6:C8)

COUNT Function Example 5

As shown in the above COUNT Formula in Excel, the COUNT function is applied on the range of values C6:C8. As shown in the screenshot below, the range does not have any valid number. So, the result returned by the COUNT function in excel is 0. The results cell B12 hence, contains number 0.

Example #6 – Empty Range

COUNT (D3:D5)

COUNT Function Example 6

As shown in the above excel COUNT formula, the COUNT function is applied to the range of values D3:D5. As shown in the screenshot below, the range does not have any numbers i.e. it is empty. So, the result returned by the COUNT function is 0. The results of cell D10 hence contains number 0.

Things to Remember About COUNT Function in Excel

  1. The data values containing numbers, dates, or a text representation of numbers (for example, a number enclosed in quotation marks, such as “1”) are counted.
  2. Logical values and text representations of numbers that you type directly into the list of parameters are counted.
  3. Error values or text which cannot be converted into numbers is not counted in Excel COUNT Formula.
  4. If the argument is an array or reference, only the numbers in that array or reference are counted in the Excel COUNT Formula. Empty cells, logical values, text, or error values in the array or reference are not counted.
  5. A further extension to the function is COUNTA which is to count logical values, text, or error values.
  6. Another extension is COUNTIF function which is to count the numbers that meet a specified criterion.

Usage of COUNT function in Excel VBA

VBA Excel COUNT function is used in the same way as that of Excel.

COUNT Function in Excel Video

Recommended Articles

This has been a guide to COUNT Function in Excel. Here we discuss the COUNT Formula in excel and how to use COUNT function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  • Excel VBA IsEmpty
  • COUNTIF Examples of Excel
  • How to Create a Correlation Matrix in Excel?
  • Excel Cell Reference | Top 3 Types
  • Example of COUNTIF with Multiple Criteria
  • INT Function in Excel (Integer)
  • AVERAGE Function in Excel
  • CORREL Excel Function (Correlation)
  • CEILING Excel Function
  • TIME Excel Function
2 Shares
Share
Tweet
Share

Filed Under: Statistical Functions in Excel

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download COUNT Function Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

CYBER WEEK OFFER - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More