Counting Month Values

[Daniel Chaparro]

As someone new to fully utilizing the power of Excel, I have run into
a brick wall regarding determining the value of a range of cells.

QUESTION
How can one determine the total number of a particular month specified
in a cell range?

Example: If 10 sets of parents submit the birth dates of their
children, how can I determine the totals for each month submitted? (2
children were born in the month of January, 1 child was born in the
month of May, etc...)

Previously, I used the "COUNTIF" formula to determine values of
content entered into cells in a particular cell range. For example, I
used the COUNTIF formula to determine how many people selected YES to
a particular question; =COUNTIF(C3:C16,"YES"). But this method does
not seem to work with date values.

Anyone have any suggestions?

 

[Domenic]

Hi Daniel,

Assuming that your list is in Column A...

=SUMPRODUCT((A1:A100<>"")*(MONTH(A1:A100)=1))

Hope this helps!