Countif function

  • Thread starter Thread starter Pascale
  • Start date Start date
P

Pascale

I am trying to count the number of records between dates. I have trie
=countif(x:x, month(a2)), where x has date formats dd/mm/yyyy. It i
returning 0, and should be returning a value.

Thanks in advanc
 
the function appears to be counting all empty fields as a january date
How do prevent this from happening
 
Pascale said:
*the function appears to be counting all empty fields as a januar
date. How do prevent this from happening? *
Click to expand...

Add the year as your second criteria...

=SUMPRODUCT(--(MONTH(A2:A100)=6),--(YEAR(A2:A100)=2004))

Hope this helps
 
Back
Top