Forum Discussion

Elise0520's avatar
Elise0520
Copper Contributor
Jul 24, 2022
Solved

Countif with excluding condition

Hello I am trying to get the total of days in a range of cells where the start time is later than 06:30 but I need to exclude the time if there is "Course* in another range os cells. I am using this...
  • OliverScheurich's avatar
    Jul 24, 2022

    Elise0520 

    =COUNTIFS(E3:E9,">06:30:00",F3:F9,"<>Course")

    Maybe this is what you are looking for.

     

Resources