| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number of rows | Excel Worksheet Functions | |||
| Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
| Counting the number of checkboxes on a spreadsheet | Excel Worksheet Functions | |||
| Counting occurrences of multiple conditions | Excel Discussion (Misc queries) | |||
| Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
Linear Mode
