Need countifs forumla to analize in a time range
I have a spreadsheet that I need some help with having a count formula count events between the timeframes 00:00-5:59 AM, 6:00am-1:29pm and 1:30pm-11:59pm, but also while observing that K2:K2000 ="360" and F2:F2000 ="K". I've been playing with some countifs and sumproducts for a while and I'm not getting anywhere. Please help!
Thanks!
Last edited by coil222 : October 1st 13 at 05:07 PM
|