I have a sheet of data that may look somethihng like this:

A B C
1 1 2
2 1 3
1 3 1

I want to set up a program that I can tell to look in the sheet and no
only count the number of 1's, but count it my column. For exmaple if
look up 1's I want the result to look like:

A = 2
B = 2
C= 1
or something like this where is gives me a tally of matches in
column. Any ideas

--
kola556
-----------------------------------------------------------------------
kola5567's Profile: http://www.excelforum.com/member.php...fo&userid=2461
View this thread: http://www.excelforum.com/showthread.php?threadid=39942