Hi All,
I am looking for a way to count a specific number in a column provided the corresponding cell in another column is a number i.e.(not text). Consider the table below as an example;
I want to count only 70% marks in column B provided the corresponding value in column C is a number. In this case the answer will be 2.
I am looking for a way to count a specific number in a column provided the corresponding cell in another column is a number i.e.(not text). Consider the table below as an example;
I want to count only 70% marks in column B provided the corresponding value in column C is a number. In this case the answer will be 2.