COUNTIF Function in Excel

Home/Excel Formulas/COUNTIF Function in Excel

What is the use of COUNTIF function?

COUNTIF Function in Excel counts all numbers in a range based on a given criteria



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

What is the syntax of COUNTIF function?

COUNTIF Function in Excel- Syntax

COUNTIF( range, criteria )

range: range of cells that you want to check the criteria and count
criteria: condition which you want to apply

COUNTIF Function in Excel – Examples

COUNTIF Function in Excel- Example 1

Example 1: counting the salaries more than 2500
Example 2: counting the number of departments named “HR”
Example 3: counting the number of occurrences Years 2011


Please refer the below article for more Statistical Excel functions.
Statistical Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

By |January 31st, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

Related pages

move worksheet to another workbookhiding formulas in excel 2013excel vba userform examplesresidential construction schedule template excelwhat is the purpose of vlookup function in excelwhat is hlookup in excel with examplehow to unlock a password protected excel sheetleft vba excelexcel filter out duplicatescollection vbacreating dashboardsadd the developer tab to the ribbon in wordms excel shortcut keyadodb connection closebelajar macro excelexcel multiple if statementhyperlinks vbaexcel hyperlink to pdfexcel vba matchhow to remove excel sheet passwordvb code excelset activesheethow to show developer tab in excelhow to unprotect password protected excel sheetiferror function excel 2010color index excel vbalistbox columnexcel vba removecolor code cells in excelhow to add pivot table in excellearning vlookup in excel 2007isempty excelactiveworkbook saveasconsolidate data from multiple worksheetsfor each in vba excelhow to merge two columns in excel 2010excel vba sortexcel in cell chartcolumns vba excelworkbooks activatespell check shortcut in excelmove tabs in excelcopy sheet excel vbavlookup a formulatechnical aptitude questions and answersmerge sheets excelvba until loopwhere is developer tab in excel 2010excel formula colorworksheet function in vbaunshare workbookexcel vba close formvba variable scopecopy excel sheet to new workbookexcel button macrohow to unhide top rows in excelrun macro excelvba excel protect sheetexcel vba userform positionexcel macro hyperlinkrecordset getrows vbaexcel vba unprotect workbook without passwordhow to unlock a locked excel filepassword vba excelhow to combine sheets in excelhow to copy worksheet in excelvlookup excel function examplesexcel vba color codesexcel colour indexworksheet functionsmerging cells excelwhat are ddl statementsvb6 with access database examplesas mainframe tutorial