Count a numbers of entries in a given month ?
 

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 ?

I'm not clear on exactly what you want but maybe idea will help. Modify to
suit.
If your col A is DATES and you want April

=sumproduct((month(a2:a200)=4)*(month(b2:b200)2))

--
Don Guillett
SalesAid Software

"Svoger" 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 ?

Hi

I think I have solved the problem. thanks

Susanne


"Don Guillett" wrote:

I'm not clear on exactly what you want but maybe idea will help. Modify to
suit.
If your col A is DATES and you want April

=sumproduct((month(a2:a200)=4)*(month(b2:b200)2))

--
Don Guillett
SalesAid Software

"Svoger" 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 ?

If you want to count blanks in a range, use '=COUNTIF(A1:A10,"")'. A1 to A10
is the range you want to enter.

"Svoger" wrote:

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 ?

You could even use '=COUNTBLANK(A1:A10)'

"ewan7279" wrote in message
...
If you want to count blanks in a range, use '=COUNTIF(A1:A10,"")'. A1 to
A10
is the range you want to enter.

"Svoger" wrote:

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 ?