Prev: counting part numbers
Next: '07 Large Operation Error (Delete / Insert Rows and/or Columns
From: Jason on 28 Apr 2010 16:34
Hello everyone-
I would like excel to count how many same part numbers i have and list them.
Such as P/N 11222=20, P/N 11333=30.

Any suggestions?

thx
From: Don Guillett on 28 Apr 2010 17:16
look in the help index for countif

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Jason" <Jason(a)discussions.microsoft.com> wrote in message
news:FC4194D7-4DD6-4D03-B15E-4FB34F689B84(a)microsoft.com...
> 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

From: grizzly6969 on 28 Apr 2010 17:24
=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
 | 
Pages: 1
Prev: counting part numbers
Next: '07 Large Operation Error (Delete / Insert Rows and/or Columns