Hi KL

It does not work. Here is a little more of what my worksheet looks like
A is the date when the project started and K is when it finished, if it is
blank the project is not finished yet.

A ........... K
1 20-01-2005 20-01-2005
2 21-01-2005 24-01-2005
3 21-01-2005
4 21-01-2005
5 21-01-2005 21-02-2005
6 27-01-2005 01-02-2005
7 31-01-2005 25-02-2005
8 02-02-2005 02-02-2005
9 04-02-2005
10 28-02-2005 01-03-2005

I want to know the numbers of projects started in January but not finished
in January, the numbers of projects started in January and finished in
January, the numbers of projects started in February but not finished in
February and last the numbers of projects started in February and finished in
February.

Susanne

"KL" wrote:

Hi Susanne,

Assuming that your data are in range [A2:B10] try the following:

=SUMPRODUCT((MONTH(A2:A10)=11)*(YEAR(A2:A10)=2004) *((MONTH(B2:B10)<11)+(YEAR(B2:B10)<2004)0))

Regards,
KL

"Susanne" wrote in message
...
I need to count a numbers of entries in a given month and then I have to
compare with another set of entries that has to be greater than a certain
month. I also has to count the numbers of empty cells. Can I use a nested
IF
function ?

It looks like this :

Date in Date finished
01-11-2004 03-01-2005
30-11-2004

I now want to calculate how many entries entered in November but not
finished in November. I want this for every month of the year.

Susanne