I have a Spread sheet which links to my Database. This sheet querys the database and puts everything in a what we call a "TAM" number order. (example D1158 , D1159 , D1125). All of these numbers are shown in Column A. Is there a way I can set a cell to count the number of D1158's there are? I have tried the count formula, but I think I am missing a step.

Thanks :confused:

Found it:

=Countif(A:A,"D1158")

Just goes to show, you just got to keep looking. :D

thanks!