Hello,
I'm a first-time poster so please excuse any mistakes. I have a problem regarding finding a number value for how often a combination of specific criteria is met.
My data is organized in multiple rows, where each downward cell represents 1 hour. The data for criteria 1 (hs <= 1) is located in the B row, while the data for criteria 2 (tp <=10) is located in the C row.
I need to find how many times Criteria 1 (I4) & 2 (I5) are met in a minimum of 6 (I6) consecutive rows in order to determine how many times a suitable operation window is open.
I have tried to use variations of COUNTIF, IF, SUMPRODUCT, and other functions, but had no success yet.
Thanks in advance!
I'm a first-time poster so please excuse any mistakes. I have a problem regarding finding a number value for how often a combination of specific criteria is met.
My data is organized in multiple rows, where each downward cell represents 1 hour. The data for criteria 1 (hs <= 1) is located in the B row, while the data for criteria 2 (tp <=10) is located in the C row.
I need to find how many times Criteria 1 (I4) & 2 (I5) are met in a minimum of 6 (I6) consecutive rows in order to determine how many times a suitable operation window is open.
I have tried to use variations of COUNTIF, IF, SUMPRODUCT, and other functions, but had no success yet.
Thanks in advance!