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"))
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"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks