|
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 |
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 |
| All times are GMT +1. The time now is 04:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com