We can use MOD() to count the number of cells containing even and odd numbers by applying it along with the SUMPRODUCT function. Let us see the steps with an example. Consider the following table containing a list of even and odd numbers. Suppose the requirement is to determine the total number of cells containing even and odd numbers and display the results in the cell range B13:B14. Then, here is how we can use the MOD() within the SUMPRODUCT() in the target cells to get the required output. • Step 1: Select the target cell B13, enter the below formula, and press Enter. =SUMPRODUCT((MOD(A2:A11,2)=0)*1) • Step 2: Select the target cell B14, enter the below formula, and press Enter. =SUMPRODUCT((MOD(A2:A11,2)=1)*1) The MOD() in the above formulas returns the remainder values obtained from dividing each number in the list by 2. Then, the cell B13 formula checks whether the MOD() output is 0 to confirm if the specific column A cell value is even. The result will be an array of TRUEs and FALSEs, where TRUE indicates the particular cell value is even. And multiplying the array range with the value of 1 will return an array of ones and zeros. Finally, the SUMPRODUCT() adds the array values to return the total count of even numbers, 4. The cell B14 formula also works similarly, except the formula checks if the MOD() output is 1 to confirm the specific column A cell value is odd.