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!
 

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
Joined
Mar 17, 2004
Messages
19,958
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,721

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

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top