number of rows/records for the specified period
I have a range of dates between 2008-02-25 till 2008-12-25
If you want a summary for each month from Feb to Dec...
Enter this formula in D1:
=TEXT(ROWS(D$1:D2)*30,"mmm")
Enter this formula in E1:
=SUMPRODUCT(--(TEXT(A$1:A$5,"mmm")=D1),--(B$1:B$5<""))
Select both D1 and E1 and copy down to D11:E11
--
Biff
Microsoft Excel MVP
"MZ" wrote in message
...
Hello!
I have a range of dates between 2008-02-25 till 2008-12-25 and I would
like to
count the number of rows which has not empty data (distance field) for the
February 2008, March 2008 etc.
These data a
Date Distance (km)
2008-02-25 25 km
2008-02-26 26 km
2008-02-27 not filled in yet
2008-02-28 not filled in yet
2008-03-01 not filled in yet
etc. etc.
February 2008 - my functions should return 2
March 2008 - my function should return 0
Can you help me how to do it using Excel 2007 functions?
Thank you in advance
Martin
|