count

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lacey - 14 Sep 2006 11:13 GMT

Hi - I'm hoping someone can help me - i have a list of employees (col A) who
have been awarded $ amounts (col B). I need to count the number of times
they have received an award... really would appreciate any help... thanks

00020084    1,500.00
00020084    1,000.00
00020084    500
00018539    1,000.00
00018539    1,500.00
00028267    1,000.00

Reply to this Message

Bob Phillips - 14 Sep 2006 11:29 GMT

=COUNTIF(A:A,"00020084")

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi - I'm hoping someone can help me - i have a list of employees (col A) who
> have been awarded $ amounts (col B). I need to count the number of times
[quoted text clipped - 6 lines]
> 00018539 1,500.00
> 00028267 1,000.00

Reply to this Message

Lacey - 14 Sep 2006 11:48 GMT

Hi Bob - thanks - this worked for the one row and idenifying the one person
- but I need to drag this formulae down looking at over 100 cells - any
ideas?
thanks

> =COUNTIF(A:A,"00020084")
>
[quoted text clipped - 9 lines]
> > 00018539 1,500.00
> > 00028267 1,000.00

Reply to this Message

Bob Phillips - 14 Sep 2006 13:09 GMT

You could refer to the cell

COUNTIF(A:A,A1)

but many numbers will repeat.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi Bob - thanks - this worked for the one row and idenifying the one person
> - but I need to drag this formulae down looking at over 100 cells - any
[quoted text clipped - 14 lines]
> > > 00018539 1,500.00
> > > 00028267 1,000.00

Reply to this Message

Lacey - 14 Sep 2006 14:34 GMT

Hi Bob - perfect - thanks heaps for your help !

> You could refer to the cell
>
[quoted text clipped - 24 lines]
> > > > 00018539 1,500.00
> > > > 00028267 1,000.00

Reply to this Message