In B3 copied across:

=COUNTIF(B$5:B$13,TRUE)