G Guest Aug 30, 2007 #3 Let's say your data is in A1:A100 =COUNTIF(A1:A100,">70%") HTH, Barb Reinhardt