number of rows/records for the specified period

M

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

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$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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Creteria Lookup(Between Dates) 8
Sum the number of days between dates by Month 16
Two question about Excel 2007 4
counting items within a date range 1
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Find then highlight in yellow 6
Excel PRICE function: How does it compute Issue Date of the Security 5
Subtotal Function 0

Top