Hi Valko,
Here's a better sample of what I am trying to do:
If you look at the sample below, you will see that I am looking at both the
Net and Area to gather the number. So if the Area has Dem, count all the
numbers under the Net. If the Area has Fre, count all the numbers under the
Net associated with Fre. There are several other items in the Area that I did
not list here and unfortunately it varies from day to day with the number of
values.

Value Month NET Rpt Cnt Count Area Case
1 1 Dem
Elim Feb 0 1 Dem
1 1 Dem
2 1 Dem
Add March 1 1 Fre
3 1 Fre
2 1 Fre
Elim March 0 1 Fre
Elim Feb 0 1 Fre
Elim Feb 0 1 Fre

4 Dem
6 Fre


"T. Valko" wrote:

If column B *always* has a value of 1 then all you need to do is count the
instances in column A:

=COUNTIF(A:A,"Dem")
=COUNTIF(A:A,"Fre")

=COUNTIF(A2:A100,"Dem")
=COUNTIF(A2:A100,"Fre")

--
Biff
Microsoft Excel MVP


"Kennedy" wrote in message
...
Trying to find a way to use a countif value that pulls back specific count
for certain values in a column. Using countif because the cell contains a
computed value that returns a value of 1
So if:
Col A Col B
Dem 1
Dem 1
Dem 1
FRE 1
FRE 1
FRE 1

The countif value would show for Dem 3 and Fre 3



.