yes =countif(a1:a100,B1)
D Don Guillett Jun 16, 2005 #2 Norman was kind to answer your question. However, is there some reason you couldn't have TRIED it first?
Norman was kind to answer your question. However, is there some reason you couldn't have TRIED it first?