View Single Post
  #1   Report Post  
coil222 coil222 is offline
Junior Member
 
Posts: 2
Default 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