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

vba range cells selectinsert comment excel shortcutms excel 2007 vlookupexcel sql server queryproject budget template excelvba excel read text filehow to work on pivot table in excel 2010application run vbaexcel insert rowneat excel tricksddl queries in sql with examplesexcel vba userform comboboxturn on autofilter excel 2010how to delete duplicate rowsvba excel listboxvba calculation manualaccess vba function return valuehow do you do a tick in excelvb script interview questions and answersexcel vba and macrostypes of column chartscopy file vb6name range in excel 2007vba sample projectsexcel 2007 concatenateprotect sheet in excelvba selected rangeadodb connection providerexcel vba clear clipboardworkbook vs worksheetexcel combine data from multiple worksheetshow to merge cells with data in excelchecklist excel templateprotect sheet excelduplicate finder excelvba open excel fileexcel vba code samplesmacro sqltextbox controlunlock a password protected excel fileworkbooks vbaexcel template schedule plannerhide cells in excelvba filenamems excel data validation listvba reference sheet by namevba declare variablenot equal vbasample excel macrosfind duplicates in excelprotect workbook in excel 2007excel vba printvba code for pivot tablehow does vlookup work in excel 2013excel vba delete rowsvba output to text filemicrosoft excel unprotect sheetexcel vba cell offsetadvanced excel shortcuts pdfconditional if statements in excelexcel macro tutorialvba fillexcel vba variantobjfso.deletefilesample excel macro codeexcel 2007 concatenatevlookup multiple matchesinsert a check boxvbexclamationhow to delete blank cells in excelhow to join cells in excelalphabetize column in excel