Forum Discussion
madbike1
Dec 19, 2021Copper Contributor
Find count of items from list and ID
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 equat...
OliverScheurich
Dec 19, 2021Gold Contributor
=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.
madbike1
Dec 19, 2021Copper Contributor