Countif with excluding condition

[Lis0520]

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!

 

[Peter_SSs]

Welcome to the MrExcel board!

Could we have a small set of sample dummy data and the expected results to test with?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.