| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number of rows/records for the specified period
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days in a running period | Excel Worksheet Functions | |||
| How do I count the number of events in a 90 day period? | Excel Worksheet Functions | |||
| How do i get rid of the period in a whole number? | New Users to Excel | |||
| Finding number of particular days in a period | Excel Worksheet Functions | |||
| number of mondays in period | Excel Discussion (Misc queries) | |||
Linear Mode
