I'm having awful trouble for something that should be so simple.
I have the below information and am wanting to count how many figures there are in a column, based on a criteria. In this case, B9 is 2, so I need a formula that counts how many occurrences in the 2 column (column C). Answer should be 4. B9 may change.
I have the below information and am wanting to count how many figures there are in a column, based on a criteria. In this case, B9 is 2, so I need a formula that counts how many occurrences in the 2 column (column C). Answer should be 4. B9 may change.