I forgot that each continuous range must be separated. This is painful but works:

=SUM(COUNTIF(INDIRECT({"D8","D22","D36","D50","D64","D78","D92","D106","D120","D134","D148","D162"}),"Sunny"))