From the course: Excel 2013 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 - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Using the COUNTIF family of functions

A category of functions that's extremely valuable when working with large lists is the COUNTIF family of functions. There is a COUNTIF, a SUMIF and AVERAGEIF and three more sophisticated variations that allow you to use multiple criteria. In this particular list here we might want to tabulate how many Kitchen items we have. It's a large list, 300 rows or so and we don't necessarily want to sort the Data but we do want to know for example, how many of our products are in the Kitchen category, Kitchen Department, Bedroom Department, Dining Department, so on and we have various entries here. Now to make this easier to see I'm going to hide a few columns here, columns C, D, E as I drag across these into, let's just say those three columns we'll hide for the moment, Right-Click and Hide. We've got a list here of all the different Departments that's been set up ahead of time, so let's zoom in a bit on this list, we'll use the Zoom Slider bar on the lower right-hand corner to zoom in a bit…

Contents