ExcelBanter - Counting number of occurrences

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting number of occurrences (https://www.excelbanter.com/excel-worksheet-functions/45664-counting-number-occurrences.html)

LyleB_Austin

Counting number of occurrences

I have a column with several hundred entries in date format m/d/yyyy. Is
there a formula to count the number of occurrences for each unique value of
yyyy? In other words how many of the dates fall within 2003, 2004, 2005,
etc. Thanks.

Hi,

How about:

=SUMPRODUCT(--(YEAR(A1:A1000)=2004))

Regards,
KL

"LyleB_Austin" wrote in message
...
I have a column with several hundred entries in date format m/d/yyyy. Is
there a formula to count the number of occurrences for each unique value
of
yyyy? In other words how many of the dates fall within 2003, 2004, 2005,
etc. Thanks.

All times are GMT +1. The time now is 07:20 PM.