From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep
Join today to access over 25,200 courses taught by industry experts.
Use COUNT() and COUNTIF()
From the course: Microsoft Office Specialist: Expert (Office 365 and Office 2019) Cert Prep
Use COUNT() and COUNTIF()
- [Instructor] Similar to SUMIF and AVERAGEIF, we have the COUNTIF function. The COUNTIF function is used if you just have one set of criteria, and if that criteria is met, Excel will count those records in your range. And of course if we have more than one set of criteria, we can use COUNTIFS. Let's take a look at our COUNTIFS workbook. And starting in column H, if I simply wanted to know the number of employees that I have I can use a very simply count function. Equals count, and of course I want to reference sales that have numbers in them. So I use my salary column, control + shift + down arrow will select that entire range. I'll go ahead and hit enter on my keyboard and I have 735 employees. But if I really want to drill down into my information and see how many employees I have in the training department, that's when I would want to use COUNTIF. One set of criteria. Equals COUNTIF. We're simply looking for…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
Use AND(), OR(), and NOT() in nested functions6m 9s
-
Use IF() and IFS() in nested functions4m 31s
-
(Locked)
Use SWITCH() in nested functions3m 38s
-
Use SUMIF(), AVERAGEIF(), SUMIFS(), and AVERAGEIFS() functions5m 2s
-
(Locked)
Use COUNT() and COUNTIF()2m 54s
-
Use MAXIFS() and MINIFS() in nested functions3m 27s
-
(Locked)
Look up data using VLOOKUP() and HLOOKUP()5m 52s
-
Use the MATCH() and INDEX() functions5m 47s
-
(Locked)
Use NOW() and TODAY() functions and calculate dates using WEEKDAY() and WORKDAY() functions8m 15s
-
(Locked)
Summarize data from multiple ranges by using the Consolidate feature3m 10s
-
(Locked)
Use What-If Analysis Goal Seek and Scenario Manager5m 57s
-
(Locked)
Calculate financial data with NPER() and PMT() functions3m 30s
-
(Locked)
Troubleshoot formulas9m 24s
-
(Locked)
Challenge: Create advanced formulas27s
-
(Locked)
Solution: Create advanced formulas9m 8s
-
-
-
-