Its not entirely clear what you want, if it is aformula to count th
number of 1's in A, then 2's in A 3's etc and to also do the same for
C D

try creating a summarytable with your levels down the side, I a
assuming that A35 is the cell with the 1 in below. The formula would b
in cell b35 this formula can be copied right and down for your entir
range

1 Countif(b$2:b$20,$A35)
2
3
4

If it is something else you require, you will have to give a bit mor
explaination

Regards

Da

--
Da
-----------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...fo&userid=2710
View this thread: http://www.excelforum.com/showthread.php?threadid=54537