R
redneck joe
Need help on this one, not a lot of time to try to learn it on my own:
I have a list of employees in column A
I have list of various job codes in column C with assigned employee
number associated with that job code in column D,
in range of row 5 through 960.
I need the formula to read the employee number in A1,
then search for that employee number in D5960,
then count the number of specific job codes in the associated column
C5:C960
Employee 7004 did xx number of TC, SC, NC, DM, etc.
Similar to this formula, but the “7004” is a variable that needs to be
read from a cell rather be an absolute, and the “TC” needs to read that
and about 10 more codes
=SUMPRODUCT(($D$5:$D$960={"7004"})*($C$5:$C$960= "TC"))
thanks for saving me, again….
j
I have a list of employees in column A
I have list of various job codes in column C with assigned employee
number associated with that job code in column D,
in range of row 5 through 960.
I need the formula to read the employee number in A1,
then search for that employee number in D5960,
then count the number of specific job codes in the associated column
C5:C960
Employee 7004 did xx number of TC, SC, NC, DM, etc.
Similar to this formula, but the “7004” is a variable that needs to be
read from a cell rather be an absolute, and the “TC” needs to read that
and about 10 more codes
=SUMPRODUCT(($D$5:$D$960={"7004"})*($C$5:$C$960= "TC"))
thanks for saving me, again….
j