Using CountIf to find total number based on 2 different cells?

[JERRADV]

I need help coming up with a formula for the following:

• IF the context of a cell in the "PRIMARY TASK" column (column J) says "Appraisals" THEN count the cells in the corresponding row in the "TENURE IN WEEKS" column (column L)

and then vice-versa:

• IF the context of a cell in the "PRIMARY TASK" column (column J) says "Order Outs" THEN count the cells in the corresponding row in the "TENURE IN WEEKS" column (column L)

For context, I am trying to find 2 different data points:

• The total number of people we have working Appraisal tasks and how many are at what week tenure
• The total number of people we have working Order Out tasks and how many are at what week tenure

This will help me figure out, for example, that I have 8 people working the Appraisal Task and 4 are at 2 weeks tenure, while 1 is at 5 weeks tenure and 3 at 11 weeks tenure. Therefore, now knowing how many I have working Appraisals and how many are at what tenure, I can calculate their expected daily productivity based on the daily goals they are suppose to meet at that specific tenure. Which I can then calculate the total number of expected tasks that we should be able to work in a day.

Can anyone assist? Thank you!

 

[Asbestos_Jen]

Is this what you're looking for?

Book1
	A	B	C	D	E	F	G	H	I
1	Tenure (in weeks)	Campus	Primary Task
2	-	GPO	-		Weeks:	5	25	50	75
3	-	GPO	-		Appraisals	0	0	0	2
4	#Value	GPO	Appraisals		Order Outs	2	5	5	7
5	54	GPO	Order Outs
6	#Value	GPO	Appraisals
7	#Value	GPO	Appraisals
8	63	GPO	Order Outs
9	69	GPO	Appraisals
10	56	GPO	Appraisals
11	#Value	GPO	Order Outs
12	20	GPO	Order Outs
13	13	GPO	Order Outs
14	11	GPO	Order Outs
15	#Value	GPO	Order Outs
16	#Value	GPO	Order Outs
17	#Value	GPO	Order Outs
18	#Value	GPO	Order Outs
19	2	GPO	Order Outs
20	2	GPO	Order Outs
Sheet1

Cell Formulas
Range	Formula
F3:I4	F3	=COUNTIFS($C$2:$C$20,$E3,$A$2:$A$20,"<="&F$2)