View Single Post
  #5   Report Post  
bigwheel
 
Posts: n/a
Default

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 ?