Do you want countif to function if
ALL of B5:B502 are May
or
ANY of B5:B502 are May
??
--
Gary's Student


"JohnD" wrote:

=IF(Info!$B$5:$B$502="May",COUNTIF(Info!$L$5:$L$50 0,"=15"),"0")
Why doesn't this formula work. Information is being pulled from an Access97
database into 'Info' worksheet. This information is then being analysed in
another worksheet using this formula in one of the cells, but it doesn't
recognise anything labelled 'May' seems count everything. Seperate cells for
other months.