I have 2 Columns A and B with following values:
Values in Cells A2 to A11 are:
1.30
1.35
1.31
1.41
1.40
1.31
1.41
1.30
1.40
1.35
Values in Cells B2 to B11 are:
4
4
3
4
4
4
3
2
2
1
The result I need is :
If range in Column A (A2 to A11) = 1.31 to 1.40,
count the NO OF CELLS in Column B (B2 to B11) where the value = 4.
QUESTION: How to use worksheet function to do it?
(The correct answer should be 3)
Values in Cells A2 to A11 are:
1.30
1.35
1.31
1.41
1.40
1.31
1.41
1.30
1.40
1.35
Values in Cells B2 to B11 are:
4
4
3
4
4
4
3
2
2
1
The result I need is :
If range in Column A (A2 to A11) = 1.31 to 1.40,
count the NO OF CELLS in Column B (B2 to B11) where the value = 4.
QUESTION: How to use worksheet function to do it?
(The correct answer should be 3)