Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 229
- Office Version
- 365
- Platform
- Windows
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"
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"