COUNTIF Random text

[isleofman]

How would I go about writing a COUNTIF function to record the number of referrals in column D from the text in column B that appear in column c? How would I paste the formula so I wouldn't have to type the text field of column B into each COUNTIF formula in column D?

For example:

email	id	ref	count
v@x.com	qxqykr		3
q@b.com	pv39h6	qxqykr	1
s@r.com	fr2dlp3		1
u@p.com	ck320k		0
b@c.com	pn2dmc	qxqykr	0
a@b.com	mdkpol	pv39h6	0
d@g.com	elspp2	fr2dlp3	0
t@y.com	msekl20		0
j@k.com	pldla39	qxqykr	0

 

[SydneyGeek]

=COUNTIF(D:D,B2)

...assuming that ID is B, Ref is D.

Fill down

Denis

 

[AlphaFrog]

<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">email</td><td style="font-weight: bold;;">id</td><td style="font-weight: bold;;">ref</td><td style="font-weight: bold;;">count</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">v@x.com</td><td style=";">qxqykr</td><td style="text-align: right;;"></td><td style="text-align: right;;">3</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">q@b.com</td><td style=";">pv39h6</td><td style=";">qxqykr</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">s@r.com</td><td style=";">fr2dlp3</td><td style="text-align: right;;"></td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">u@p.com</td><td style=";">ck320k</td><td style="text-align: right;;"></td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">b@c.com</td><td style=";">pn2dmc</td><td style=";">qxqykr</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">a@b.com</td><td style=";">mdkpol</td><td style=";">pv39h6</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">d@g.com</td><td style=";">elspp2</td><td style=";">fr2dlp3</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">t@y.com</td><td style=";">msekl20</td><td style="text-align: right;;"></td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">j@k.com</td><td style=";">pldla39</td><td style=";">qxqykr</td><td style="text-align: right;;">0</td></tr></tbody></table><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D2</th><td style="text-align:left">=COUNTIF(<font color="Blue">C:C,B2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D3</th><td style="text-align:left">=COUNTIF(<font color="Blue">C:C,B3</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D4</th><td style="text-align:left">=COUNTIF(<font color="Blue">C:C,B4</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D5</th><td style="text-align:left">=COUNTIF(<font color="Blue">C:C,B5</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D6</th><td style="text-align:left">=COUNTIF(<font color="Blue">C:C,B6</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D7</th><td style="text-align:left">=COUNTIF(<font color="Blue">C:C,B7</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D8</th><td style="text-align:left">=COUNTIF(<font color="Blue">C:C,B8</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D9</th><td style="text-align:left">=COUNTIF(<font color="Blue">C:C,B9</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D10</th><td style="text-align:left">=COUNTIF(<font color="Blue">C:C,B10</font>)</td></tr></tbody></table></td></tr></table><br />