Count names

[Guest]

Hi Folks,
I have spreadsheet that in not formated in coulmns. However, what I need to do is count how many times the name "vendor number" comes up in the spreadsheet. That way I can count how many vendors I have.
Thanks,
DJ

 

[Frank Kabel]

Hi
without VBA you may use
=COUNTIF(A1:X200,"vendor number")

--
Regards
Frank Kabel
Frankfurt, Germany

Hi Folks,
I have spreadsheet that in not formated in coulmns. However, what I

need to do is count how many times the name "vendor number" comes up in
the spreadsheet. That way I can count how many vendors I have.

 

[Guest]

Thanks Frank
Had to change it t
=COUNTIF(A1:A500,"Vendor number*"
Since the spreadsheet is not formated in coulmns
Thanks again
DJ