Count ifs with cell reference?

[Rick187]

Hi,

Is is possible to add a cell reference for the text in a count ifs formula?

Here is what I'm trying to do:

I have 195,000 URL Links in one column, I have 2,000 unique URL's in the other column, the column that has 195,000 urls are duplicates of the original 2,000 URL.s

For each URL, I want the total number of URL's in the other column to display?

For example:

www.google.com is in Column B or in a different tab

www.google.com is in Column C and has 5 rows of this

so Column C looks like this

www.google.com
www.google.com
www.google.com
www.google.com
www.google.com

Column B just has www.google.com

In Column C I want it to say "5" next to www.google.com

I hope this makes sense.

Can anyone help with this?


EDIT:
I'd like it it to pull the text of the URL from the cell instead of me individually having to type in the URL like this "=COUNTIFS(D19:D21,"Yes",C19:C21,"http://www.google.com")", I'd like it to pull the text from the Cell so it can be like this: "=COUNTIFS(D19:D21,"Yes",C19:C21,""E18")" - I tried that but it didn't work. It only works when I add the actual text of the URL in the formula.

 

[Weazel]

something like...

=COUNTIF($A$2:$A$6,"="&B2)

=COUNTIFS(D19:D21,"Yes",C19:C21,"="&B2)