I have a large table of data in Excel 2013 similar to the following:

```
A(Include?)  B(Name)       C(Region)

   1        John Doe        North
   0        Jim Stevens     South
   0        Tom Brooks      West
   1        Bob Smith       West
   1        Mike Thomas     North
   0        Steve Adams     East
   1        John Smith      Northwest

```

I need help coming up with an Excel formula that will show me the count of the most frequently occurring **Region** name, but only if the corresponding **Include?** value is equal to 1.

In this example, the formula that I need would output the number 2, because North is the most frequently occurring entry in the **Region** column, while only counting the entries whose **Include?** value is equal to 1.

I've been able to find the most frequently occurring region (without regard for the include column) using the following array function:

```
=INDEX(C:C,MODE(IF(C:C<>"",MATCH(C:C,C:C,0))))

```

I was then able to find the number of times that this value appears in the column using:

```
=COUNTIF(C:C,INDEX(C:C,MODE(IF(C:C<>"",MATCH(C:C,C:C,0)))))

```

However, when I try to account for the **Include?** column, I do not get the correct answer. My best guess was:

```
=COUNTIFS(C:C,C:C,INDEX(C:C,MODE(IF(C:C<>"",MATCH(C:C,C:C,0)))),A:A,1)

```

It appears that this formula is still finding the original **Region**, and simply telling me the number of times that it's occurring in the rows where **Include?** is equal to 1, not recalculating the most frequently occurring region based on this additional limitation.

I'm expecting that the required formula would somehow combine `COUNTIFS` and/or `SUMIFS` and/or some `INDEX+MATCH` combo, but I'd be open to other options.