Hi there!

To count the number of even or odd numbers in a column, you can use the COUNTIF function with a criteria that checks if the number is even or odd.

Here's how you can do it:

1. Insert a new column next to the column with the numbers you want to count.
2. In the first cell of the new column, enter the formula =MOD(A1,2), where A1 is the first cell of the column with the numbers you want to count. This formula will return 0 if the number is even, and 1 if the number is odd.
3. Copy the formula down to the rest of the cells in the new column.
4. To count the number of even numbers, use the formula =COUNTIF(B:B,0), where B:B is the column with the results of the MOD formula. This formula will count the number of cells in the column that contain 0, which represents even numbers.
5. To count the number of odd numbers, use the formula =COUNTIF(B:B,1), where B:B is the column with the results of the MOD formula. This formula will count the number of cells in the column that contain 1, which represents odd numbers.