Using the COUNTIFS statistical function

In our previous edition book, Learn Microsoft Office 2019, we learned all about the COUNTIF function. Let's look at an example to recap this function, and explore the COUNTIFS function at the same time.

Recapping the COUNTIF function

In the next topic, we will expand on prior knowledge and discover how to resolve two sets of data by locating missing data by comparing two tables. There are, of course, many methods (functions and tools) to achieve this type of scenario in Excel. In this example, we will use COUNTIF to achieve this:

1. Open the workbooks named RECON1.xlsx and RECON2.xlsx to follow along with this example.
2. Locate the first worksheet in the RECON1.xlsx workbook. On this sheet, we have a list of wines and sales, including a WV No column (for the wine ID). We have recently had a huge number of workbooks transferred from our previous drive and notice that we seem to be missing some data and have located a second...