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

[G-Matriix]

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.....

Please help!

 

[Scott Huish]

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]

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]

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]

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]

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]

I'm sorry but.......

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

It works Great!

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