Count of "Yes"

[Tragertt]

I need a count of all the days that have a yes in it. 

Student ID	Date	Day Present
123456	8/11/2022	Yes
123456	8/12/2022	Yes
123456	8/13/2022	No
123456	8/14/2022	Yes

I have another virtual column where I want to display a count of all the dates with a yes in it, in this case it would be 3 , Any ideas?

[DroidTeo]

I think you should use the COUNT() expression

Here the guide COUNT() 

Something like

COUNT(SELECT(Student[ID], (Day Present = TRUE), TRUE))

[Tragertt]

I tried this

Select ([Student ID].[Email], ([Student ID] = [Student ID].[Student ID]), True)

Is not working, says invalid inputs.

[Steve]

SELECT() - AppSheet Help