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