Greg

=COUNTIF(A1:D100,123)

Your number being 123


Gord Dibben Excel MVP

On Thu, 17 Mar 2005 15:59:17 +1030, "Greg B" wrote:

what function do I used to have excel search through columns and show how
many times the number I want appears?