Database look up
 

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

Database look up
 

=countif(A:A,1)
=countif(B:B,1)
=countif(C:C,1)

--
Regards,
Tom Ogilvy

"kola5567" wrote in
message ...

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 not
only count the number of 1's, but count it my column. For exmaple if I
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 a
column. Any ideas?


--
kola5567
------------------------------------------------------------------------
kola5567's Profile:
http://www.excelforum.com/member.php...o&userid=24614
View this thread: http://www.excelforum.com/showthread...hreadid=399428