Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

MICROSOFT EXCEL COUNTIF FUNCTION

Courtesy of
DJH Training & Application Solutions Inc.

Use COUNTIF to conditionally count a range of values or text, based on a single criterion

Would you like to know how many employees work in a particular department? Or how many sales were made by a specific rep? Or perhaps how many sales came in over or under target?  COUNTIF will quickly and easily accomplish this!

In the example below, we count the number of employees by department.

 

Step 1. Set up your data correctly, preferably converting it to a table

 

Step 2. Add the COUNTIF formula the the Number of Employees column in the table below.

 

DETAILED EXPLANATION

SYNTAX: =COUNTIF(Range in which Criteria is found ,Criteria)

 

EXAMPLE 1: Formula example if referring to a table range (tables are preferable, as will expand/contract as add/remove data):

=COUNTIF(tblEmployeeData[Department],[@Department])

 

EXAMPLE 2: Formula example if referring to a regular data range:

=COUNTIF($D$4:$D$22,E27)           

OR         

=COUNTIF($D$4:$D$22,"Accounting")

 

 

 

 

 

 



More Newsletter Articles

© 2018 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 25 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.