Hi All,

Using this to count number of occurrences between given dates

=COUNTIF($AF$17:$AF$2008,"="&"1/2/2009")-COUNTIF($AF$17:$AF$2008,""&"28/2/2009")

Now want to add an if function i.e if $B$17:$B$2200="repair" then count
using the above
Any ideas?
Cheers
Jim