I want to count the times John was in the blue room and it was a thursday. I played with **COUNTIFS** and **WEEKDAY** and checked the documentation. 

I tried **COUNTIFS** with two conditions but got errors or 0 as a result.

![Click to see the excel sheet screenshot](https://i.stack.imgur.com/vgTxQ.jpg)