View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
grizzly6969 grizzly6969 is offline
external usenet poster
 
Posts: 79
Default counting part numbers

=countif(A2:A100,"=11222")
assuming your part numbers are in column A
--
grizz


"Jason" wrote:

Hello everyone-
I have bunch of part numbers and I would like excel to tell me how many of
each part number I have.

let's say
P/N 11222= 1
P/N 11333= 2