| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count By Month
If you're interested in all the month/years, you may want to learn about
Data|Pivottable. It's a quick way to summarize data and you can group your dates by year and month. Shoelaces wrote: "Teethless mama" wrote: =SUMPRODUCT(--(TEXT(A2:A100,"m")="5")) If I am not mistaken, this returns how many records are in the month of May. I am interested in how many records are in May 2005, how many are in May 2006, and how many are in May 2007 individually, not collectively. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count # of Saturdays in a month | Excel Discussion (Misc queries) | |||
| Count reports per month | Excel Worksheet Functions | |||
| Count the dates in a month | Excel Discussion (Misc queries) | |||
| count by month | Excel Worksheet Functions | |||
| PivotTable - Count by Month | Excel Worksheet Functions | |||
Threaded Mode
