ExcelBanter - countif dependent on two columns?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - countif dependent on two columns? (https://www.excelbanter.com/excel-discussion-misc-queries/106733-countif-dependent-two-columns.html)

Rob

countif dependent on two columns?

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

Biff

countif dependent on two columns?

Try this:

=COUNTIF(A$1:A$100,B1)

Biff

"rob" wrote in message
...
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

Dave Peterson

countif dependent on two columns?

Maybe...

=countif(a:a,b1)

rob wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 03:07 PM.