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

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

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

Reference:

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

LIMITED TIME OFFER
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 selection.deleteuse of vlookup in excel 2010excel color cellsconcatenate excel 2007vba sort columnwhat is the len function in excelcost estimate spreadsheet templatehow to label columns in excelexcel vba programming pdfexcel macro save as xlsxexcel if statement blankhow to find duplicate numbers in excel 2007excel vba option buttonsexcel aptitude questionsexcel macro to select a cellexcel vba sortingexcel color duplicatesmacro examples in excelsearch duplicates in excelddl command in sqlconcatenate vbavba macro for loopcool vbs codeshow to write a excel macrovba excel formvba calculatevba delete sheetvbs copy foldervba excel addresssas isnumericexcel tutorial beginnersvba print functionhow to sort in ascending order in exceldefine activex controlexcel shortcuts keys listmessage box vba accessbasics of vbaexcel macro coding tutorialvlook up examplessas online tutor advanced programmingexample of vlookup functionaccess vba file existsremove password excel workbookms access vba message boxproject costing excel templateexcel for beginnersvba sort arraycounting duplicate values in exceldelete row macrodim fsoremove blank cells in excel formulaautofilter macrovba programs for excelvba sqrt functionvba to open excel file from foldercreate excel vbahow to break password in excel sheet3d chart excelexcel 2007 advanced tutorial3d scatter excelvba display messagexml to xlsx converterexcel vba worksheet nameopentextfileaccess vba is not nullmerging rows in excelvba update sqlconnection string in vbaexcel formula to merge cellsaccess msgboxbasic vba tutorialmacro excel buttonfree excel userform templateshow to create command button in excelvba data validation listexcel cylinder chartvlookup alternativeexcel unlock cell