number of rows/records for the specified period

[MZ]

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 are:
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

 

[T. Valko]

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$12)*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