Thread: Count If value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Count If value

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