How to count same numbers in a coluum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FPA1869 - 24 Sep 2004 22:31 GMT

I have a large Db with 38 different numbers. I would like to count th
number of each value (number)

Reply to this Message

Frank Kabel - 24 Sep 2004 22:45 GMT

Hi
=COUNTIF(A1.A100,number)

or use a pivot table for this

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I have a large Db with 38 different numbers. I would like to count

the

> number of each value (number).
>
[quoted text clipped - 3 lines]
> FPA1869's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14708
> View this thread: http://www.excelforum.com/showthread.php?threadid=263367

Reply to this Message