Finding values in 2 columns

[Executioner]

Hi everyone,
I'm not really sure how to handle this problem. I tired the COUNTIF function, but I don't think its the correct one to use because the data is in another column.

In COLUMN F I have text data: E201, E202, E203, through E221 and ends at row 903.
In COLUMN C I have text data such as EDD2062647.

I want my formula to look in COLUMN F first for the values only: E207, E209, E212, E213, then go to COLUMN C and find all data that starts with EDD* and give me the total number of those records.

I also tried VLOOKUP, but I'm confused because of the 2 different criteria that are needed.

I'm using Excel version 2003.

 

[markmzz]

Thanks.

That does not work also. I did try the {} brackets by pressing ctrl-shft-enter.

I'll try to explain this again.

In column F2:F903
I have text values E201, E202, E203, E204 through E221

In column C2:C903
I have text values EDD2062647, EDD2052849, 20029, 18745, EDD2045678, etc

I need to have Excel 2003 select all the cells that have the E207, E209, E212, and E213 data values only. When those cells are found, what is the corresponding value in column C IF it has a value that starts with EDD only. Then count all of these values that have EDD and place the result in C916.

Executioner,

Look at this:

Note: the range G1:G4 have the text values E207, E209, E212, and E213.

<b>Excel 2007</b><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 /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;">E207</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;;">DD2062648</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">E221</td><td style="text-align: center;;">E209</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;;">DD2062649</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">E209</td><td style="text-align: center;;">E212</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;;">DD2062650</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">E218</td><td style="text-align: center;;">E213</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;;">DD2062651</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">E208</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">899</td><td style="text-align: center;;">EDD2052849</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;">E205</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">900</td><td style="text-align: center;;">EDD2062647</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;">E201</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">901</td><td style="text-align: center;;">20029</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;">E207</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">902</td><td style="text-align: center;;">20029</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;">E216</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">903</td><td style="text-align: center;;">20029</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;">E205</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">904</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">914</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">915</td><td style="text-align: center;;">Result</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">916</td><td style="text-align: center;;">104</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">917</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">918</td><td style="text-align: center;;">*********</td><td style="text-align: center;;">*********</td><td style="text-align: center;;">*********</td><td style="text-align: center;;">*********</td><td style="text-align: center;;">*********</td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet11</p><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>Array 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">C916</th><td style="text-align:left">{=SUM(<font color="Blue">(<font color="Red">FIND(<font color="Green">"EDD",IF(<font color="Purple">ISNUMBER(<font color="Teal">FIND(<font color="#FF00FF">"EDD",C2:C903</font>)</font>),C2:C903,"REDD"</font>)</font>)=1</font>)*ISNUMBER(<font color="Red">MATCH(<font color="Green">F2:F903,G1:G4,0</font>)</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
Markmzz