Sumproduct 2 columns and Strings

[Kemidan2014]

The data is pretty simple and i have not updated by Xl2bb yet. but i have 2 columns of data
first column is just a string value of either "OK" or "NG". the 2nd column is a text string of 3 characters to which I have a list of all the possible combinations
for example "K13, "KK3", "KM3" first letter represents a month, 2nd is a day, 3rd is line number

I am trying to build a pareto with out hand counting

here is my sumproduct formula so far but all i get are "0" as a result
=SUMPRODUCT((D$4:E$271="NG"),(D$4:E$271=N22&"*"))

I have also tried =SUMPRODUCT((D$4:E$271="NG")*(D$4:E$271=N22&"*")) which got same result

the N22 in this case is a cell in my list of combinations in this case is "KK"
essentially in this example what am trying to ask is "How many times with in range of D4:E271 does NG and KK* occur next to each other in the same row"

 

[DanteAmor]

Try:

varios 30oct2023.xlsm
	D	E	F							M	N	O
3	OK/NG
4	OK	K13
5	OK	KK3
6	OK	KM3
7	NG	K13
8	NG	KK3
9	NG	KM3
10	OK	KK3
11	NG	KK3
12
13
14
15
16
17
18
19
20
21
22											KK	2
Hoja3

Cell Formulas
Range	Formula
O22	O22	=SUMPRODUCT((D4:D300="NG")*(LEFT(E4:E300,2)=N22))