Basically I can't figure out how to count using the following criteria if A:A="LOGON" and C:C<"9:00"


LOGOFF 03/02/2009 8:08
LOGON 03/03/2009 8:20
LOGOFF 03/03/2009 2:31
LOGON 03/04/2009 9:00
LOGOFF 03/04/2009 19:22
LOGON 03/05/2009 8:27

ive tried doing =SUM(IF(A:A="LOGON",1,0)*IF(C:C<"9:00"))
and =COUNT(IF(A:A="LOGON",IF(C:C<"9:00"))

any help would be appreciated.