Hi everyone,
I need a formula to count the number of cells in a column only containing a certain value, if they are in the row immediately below the row containing another value in another column.
Here is an example (columns A, B, rows 1-6):
<tbody>
</tbody>
I want to count how many y in B are in a row below the row of a cell containing x in A;
in the above example, this number is 2: the y on row 2 follows the x in row 1, and the y in row 4 follows the x in row 3.
Thanks!
I need a formula to count the number of cells in a column only containing a certain value, if they are in the row immediately below the row containing another value in another column.
Here is an example (columns A, B, rows 1-6):
A | B | |
1 | x | |
2 | y | |
3 | x | y |
4 | x | y |
5 | ||
6 | x | y |
<tbody>
</tbody>
I want to count how many y in B are in a row below the row of a cell containing x in A;
in the above example, this number is 2: the y on row 2 follows the x in row 1, and the y in row 4 follows the x in row 3.
Thanks!