From the course: Excel 2016 for the Mac: Managing and Analyzing Data
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
SUMIF and COUNTIF and related functions - Microsoft Excel for Mac Tutorial
From the course: Excel 2016 for the Mac: Managing and Analyzing Data
SUMIF and COUNTIF and related functions
- [Instructor] We're looking at a worksheet called COUNTIF-SUMIF in the Chapter Six file. Count If and Sum If are two of six different functions all interrelated, similar in structure. Three of them, count if, sum if, and average if, and their plural counterparts, count ifs, sum ifs, and average ifs. As we're looking at this list, question might occur, or we're scrolling up and down, perhaps, looking at it. One of these departments catches our eye. How about Logistics here, that's interesting. How many people are there, I wonder, or how many people are in Operations? The count if function can be used pretty simply and directly to answer the question, as we're about to answer it here, how many people are in Logistics? =countif begins with the location that we're looking at, where are we finding, or where would we find these departments? They're all in column C, comma, and what are we looking for? If this is a nearby cell, and it is, it's over in cell K-11, we'll click it. It appears in…
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.