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

G-Matriix

Board Regular
Joined
Sep 20, 2006
Messages
139
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!
 

Some videos you may like

Excel Facts

Links? Where??
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
Joined
Mar 17, 2004
Messages
19,955
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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
Joined
May 19, 2002
Messages
8,458
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
Joined
Sep 20, 2006
Messages
139
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
Joined
Mar 10, 2004
Messages
19,298

ADVERTISEMENT

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
Joined
May 19, 2002
Messages
8,458
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
Joined
Sep 20, 2006
Messages
139
I'm sorry but.......

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

It works Great!

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

Watch MrExcel Video

Forum statistics

Threads
1,108,612
Messages
5,523,896
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top