Find count of items from list and ID

[madbike1]

Hello All,

Having trouble finding an equation in Excel that can solve a problem.

The sheet as column A (a-z), column B (Employee ID 1,2,3,4,5,1,2,3,etc), and column C (a,b,c)

I can create an equation to find the number of instances of the column C list that are in column A (sumproduct(countif()).  I can also create an equation to find the number of items in the C list that are in A and also are assigned to a specific number in B, but this requires the 3 lists to be the same length.

Is there an equation that can find the number of items in Column A that are in column C and belong to a specific employee ID, column B, where the 3 column lengths can be different.

[#2]

@madbike1 

=COUNT(IF((TRANSPOSE(C1:C3)=A1:A25)*(B1:B20=D1),B1:B20))

Is this what you are looking for? Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.

[#3]

@OliverScheurich 

This works

Thanks