Countif - Only with specific cells in a column

Originally Posted by 6StringJazzer

Try this. I would be happy to test it if you provide your file.

Formula:

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

ETA: Note that this formula is not movable because the range reference is text.

Almost got it.


Jeff,
The formula does not work with more than one cell in it. When I remove all the cells, except for D8, it works fine. I tested by changing the contents from Sunny to Shade. If I add the next cell to be looked at D22, I get a #Ref! (Moving of deleting cells caused an invalid cell reference , or function is returning reference error).
The total should be 3.

Thanks
Don