Database look up

[kola5567]

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?

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"kola5567" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>