# 2 Criteria Help! Stumped??????????

#### G-Matriix

##### Board Regular
Hello All,

I need some help!

I am keep track of the number of jobs an employee does. I'm and trying to get the value of a cell if it meets two criteria.

Example:
If A2:A90 contain "Joe" and B2:B90=September then give me C2 in the same row.

So if these two criteria are true then give me C2 in the same row where the two criteria were true

Not sure how to write the formula for this??????

I was trying

[/code]
{=VLOOKUP(IF(AND('Team Data'!A2:A15='Coordinator Profile'!D2:E2,'Team Data'!B2:B15='Coordinator Profile'!D6:E6),0,0),'Team Data'!A2:T14,4,FALSE)}

It is something I am doing wrong.....

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### Scott Huish

##### MrExcel MVP
Are you trying to sum the values in Column C based on these criteria? If so, perhaps:

This assumes you have a text "September" in B2:B90

=SUMPRODUCT(--(\$A\$2:\$A\$90="Joe"),--(\$B\$2:\$B\$90="September"),\$C\$2:\$C\$90)

If you actually have dates in B2:B90:

=SUMPRODUCT(--(\$A\$2:\$A\$90="Joe"),--(MONTH(\$B\$2:\$B\$90)=9),\$C\$2:\$C\$90)

#### texasalynn

##### Well-known Member
I am keep track of the number of jobs an employee does. I'm and trying to get the value of a cell if it meets two criteria.

Example:
If A2:A90 contain "Joe" and B2:B90=September then give me C2 in the same row.

So if these two criteria are true then give me C2 in the same row where the two criteria were true

=sumproduct((A2:A90-"Joe")*(month(B2:B90)=9))
if the area is actual dates use what I've shown, otherwise change the criteria to
=sumproduct((A2:A90="Joe")*(B2:B90="September"))

#### G-Matriix

##### Board Regular
I am not trying to sum the products in column C. I just want the value. What ever is in Column C

Those values are typed in manually

Thanks

#### Domenic

##### MrExcel MVP

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=INDEX(C2:C90,MATCH(1,IF(A2:A90="Joe",IF(B2:B90="September",1)),0))

Note that formula would need to be amended if Column B contains true date values.

Hope this helps!

#### texasalynn

##### Well-known Member
I am keep track of the number of jobs an employee does. I'm and trying to get the value of a cell if it meets two criteria.

but you said in your original post you want the total?
But I guess you can change your mind :wink:

#### G-Matriix

##### Board Regular
I'm sorry but.......

Man!!!!!!!!!!! You are awesome!!!!!!

It works Great!

Thanks Alot!!!!!!!!!!!

Replies
4
Views
53
Replies
8
Views
82
Replies
13
Views
167
Replies
2
Views
41
Replies
8
Views
98