How to use WEEKDAYS function inside a COUNTIFS function

[alavna]

Hi all.
A simplified version for the purpose of this question looks like this:

Date	Day	Red Room	Blue Room
01.06.2016	Wednesday	John	Michael
02.06.2016	Thursday	John	Robert
03.06.2016	Friday	William	David
04.06.2016	Saturday	Richard	John
05.06.2016	Sunday	Michael	Robert

<tbody>
</tbody>

I want to count how many times John was in the red room and it was a sunday.
I played with COUNTIFS and checked the documentation but i am still doing it wrong.
Without the weekday condition it would be easy with countif(the range; the name)

Any suggstions?

thank you

 

[Jonmo1]

If you have the DAY already listed as a Text string in column B, try

=COUNTIFS(B:B,"Sunday",C:C,"John")

 

[alavna]

thanks a lot. it works

 

[Jonmo1]

You're welcome