O
OzzyJim
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
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