You want a Pivot Table. It will do everything you want simply and quickly.

Regards,
Fred

"Kennedy" wrote in message
...
Thanks for the replies....
Column B will have relevance in the formula. Specifically, I am counting
the
actual number returned. While I onlyu put 1 in column B, the return value
could be 2, 3, 4, etc....
So what I would like to do is say, count all the numbers in column B for
the
Dems in column A and ive me a total, then count all the numbers in column
B
for Fre and give me a total.

"FSt1" wrote:

hi
afterthought..
column B would have relevence if you were using SumIf.

which are we talking about??

regards
FSt1

"FSt1" wrote:

hi
countif....
=countif(A1:A20,"Dem")
results = 3
column B has no relevence.

what problems are you haveing?

Regards
FSt1

"Kennedy" wrote:

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