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.
Hi,
try something along these lines:
=SUMPRODUCT(--(A1:A100="LOGON"),--(C1:C100<TIME(9,0,0)))
Note that in Excel 2003 you cannot specify a whole column with SUMPRODUCT, so you cannot use A:A but must use a range like A2:A5000 instead.
cheers
wow thank you sir, i spent an hour trying to figure this out.
/me bows down
Actually, it would be lady, not sir.wow thank you sir, i spent an hour trying to figure this out.
/me bows down
/gracefully nods in acceptance
Thank you miss, excuse my ignorance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks