| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count According to Date
I need a formula that will count the number of occurances a month/year occur.
I have a column with dates mm/dd/yy. I have another column with mm/yy to represent closings. Any help is appreciated! A B C Plan Elevation Projected Close - Year 2636 C Dec-05 3572 C Dec-05 3356 A Jan-06 3572 C Dec-06 2896 A Feb-06 Closings answer should be Dec-05 2 Jan-06 1 Feb-06 1 Mar-06 0 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count According to Date
=SUMPRODUCT(--(TEXT($A$2:$A$20,"yymm")=TEXT(M1,"yymm"))
where M1 holds the test date -- HTH RP (remove nothere from the email address if mailing direct) "Lori" wrote in message ... I need a formula that will count the number of occurances a month/year occur. I have a column with dates mm/dd/yy. I have another column with mm/yy to represent closings. Any help is appreciated! A B C Plan Elevation Projected Close - Year 2636 C Dec-05 3572 C Dec-05 3356 A Jan-06 3572 C Dec-06 2896 A Feb-06 Closings answer should be Dec-05 2 Jan-06 1 Feb-06 1 Mar-06 0 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
| count date ranges | Excel Worksheet Functions | |||
| How do I count occurences in a date range? | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count the occurances of a month in a range of date fields | Excel Worksheet Functions | |||
Linear Mode
