# 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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### 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
0
Views
315
Replies
0
Views
120
Replies
4
Views
334
Replies
8
Views
154
Replies
13
Views
614

1,141,221
Messages
5,705,100
Members
421,378
Latest member
CarlosDuran

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back