From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using the COUNTIF family of functions

Using the COUNTIF family of functions

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using the COUNTIF family of functions

- In this worksheet called COUNTIF, we're seeing a list of our products in column C. Quick Look seems to indicate that there are some duplicates, but we've got different sizes, based on what we're seeing in column D, also different colors. And for the year here, let's say, we're half year or quarter, it's not indicated. We've got the Price of each Item, how many were sold, and our total Revenue. And off to the left, each Item, we can see, is in a different Category. There are different Categories, different Departments here. Over in column J, we want to track how many Kitchen Items we've sold. So looking at the list over on the left hand side, you can begin to imagine. We see Kitchen in column B here and there. We want our totals just for Kitchen. Now, in order to make this easier to see for you, I'm going to hide some of the columns and then zoom in. So I'm going to hide columns D and E. We don't really need to see them. Drag across the top, right-click, and Hide. And using the…

Contents