Forum Discussion
Elise0520
Jul 24, 2022Copper Contributor
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 formula:
=COUNTIF(E3:E9,">06:30:00") -SUMPRODUCT(COUNTIF(F3:F9,"Course"))
It is working when I have time after 06:30, but it comes negative result if I have 06:30 time and Course happening at the same time. Not sure if that makes sense.
Please I really would appreciate any help! Thanks!
4 Replies
- SergeiBaklanDiamond Contributor
- Elise0520Copper ContributorHi. I've already got the answer. Thank you very much!
- OliverScheurichGold Contributor
- Elise0520Copper ContributorYes! It works now! Thank you very much! 😉