I hope someone is able to help me with this problem...I've been banging my head all morning trying to find a solution!
I'll try to explain it as simply as possible!
Column A has a set of figures.
Column B has a set of figures and I want to count the number of times a cell in this column is greater than the figure in the corresponding cell in Column C. (e.g. count if B2 > C2).
But this should only be counted when the figure in Column A is less than a given criteria.
So, for example. When the figure in a cell in range A2:A20 <1.70 and the figure in the corresponding row in Column B is greater than the figure in the corresponding row in Column C it would count the result.
e.g.
A2 = 1.90 B2 = 2 C2 = 1 (Answer = 0 because A2 is 1.70 or higher)
A3 = 1.60 B3 = 1 C3 = 2 (Answer = 0 because C3 is greater than B3)
A4 = 1.50 B4 = 3 C4 = 0 (Answer = 1 because all criteria are met)
So how do I write a formula to get the total count of 1 in the example?
Countifs may be the solution but I'm struggling with the use of comparing a value in one range (i.e a column) with the value in another range.
Thanks for any help you can give!
Bookmarks