Counting the Number of Dates with Matching Month Criteria





Problem:

The following formula was written to count the number of dates in column A that matched the month criteria in cell B2.
=COUNTIF(MONTH(A2:A6),B2)
However, on entry, an error occurred and the formula could not be used.

Solution 1:

Use the SUMPRODUCT and MONTH functions as shown in the following formula:
=SUMPRODUCT(–(MONTH(A2:A6)=B2))

Solution 2:

Use the SUM, IF, and MONTH functions as shown in the following Array formula:
{=SUM(IF(MONTH(A2:A6)=B2,1))}



Leave a Reply

Your email address will not be published. Required fields are marked *


9 × five =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>