Thats all i have no clue. Is there a simple formula to do this, and why
am i seeing stuff about visualbasic to accomplish this? If there is no
almost one line formula, what software can i use for this task? I've
tried this : =SUMPRODUCT(--(ColorIndex( A3:A167,TRUE)=3))
i keep gettin a name error and when i change SUMPRODUCT to COUNT, i
just get 0. But no name errors either. Any suggestions??????