Quote Originally Posted by Ikaabod
How does this work for you?
=SUMPRODUCT(--(ColorIndex(A1:A100,TRUE)=3),--(A1:A100<>""))

This worked exactly as I need it to. Thanks very much