Hello. I'm posting here quite often lately... having difficulty with several functions I've learned from here
I am trying to make a cell count the number of data that meets 2 criteria. For example:
Col.A Col.B
AAA 10
AAA 9
CCC 10
BBB 10
DDD 9
AAA 10
BBB 8
BBB 9
CCC 8
Cell C1 = <Input criteria 1> AAA
Cell D1 = <Input criteria 2> 10
Then in E1, for example, I want to show "2", because there are two instances of AAA with "10".
This is the formula I am currently using, but it's not showing the correct answer...
=SUMPRODUCT((A2:A10=C1)*(B2:B10=D1)/COUNTIFS(B2:B10,B2:B10&"",A2:A10,A2:A10&""))
I tried: =SUMPRODUCT((A2:A10=C1)*(B2:B10=D1)/COUNTIFS(B2:B10,B2:B10&D1,A2:A10,A2:A10&C1)) but this gives me #DIV0 error.
Could someone please help me solve this? I appreciate your help in advance.
Bookmarks