countif dependent on two columns?

R

rob

Can someone help me with this?
I would like to put a function into a cell in column C that will take the
text that is entered in a cell in column B and see how often it appears in
column A, returning the result into the cell in column C.

Thanks in advance,
rob
 
D

Dave Peterson

Maybe...

=countif(a:a,b1)

Can someone help me with this?
I would like to put a function into a cell in column C that will take the
text that is entered in a cell in column B and see how often it appears in
column A, returning the result into the cell in column C.

Thanks in advance,
rob
Click to expand...
 
Top