How to use WEEKDAYS function inside a COUNTIFS function

[alavna]

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

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Day[/TD]
[TD]Red Room[/TD]
[TD]Blue Room[/TD]
[/TR]
[TR]
[TD]01.06.2016
[/TD]
[TD]Wednesday[/TD]
[TD]John
[/TD]
[TD]Michael[/TD]
[/TR]
[TR]
[TD]02.06.2016[/TD]
[TD]Thursday[/TD]
[TD]John[/TD]
[TD]Robert[/TD]
[/TR]
[TR]
[TD]03.06.2016[/TD]
[TD]Friday[/TD]
[TD]William[/TD]
[TD]David[/TD]
[/TR]
[TR]
[TD]04.06.2016[/TD]
[TD]Saturday[/TD]
[TD]Richard[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]05.06.2016[/TD]
[TD]Sunday[/TD]
[TD]Michael[/TD]
[TD]Robert[/TD]
[/TR]
</tbody>[/TABLE]










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