Hi,
I have basic Excel knowledge and been trying to figure out how to count instances of values based on a defined range.
Example:
Column A
1
11
21
Column B
10
20
30
Count (Column C)
?
?
?
Scores
2
4
20
35
I want excel to look at the “scores” and update the Count column (C) by adding each instance within the range. i.e.for above example count in row one should be 2 because scores 2 and 4 are within the range of column A and B.
Likewise count should be 1 for row 2 and 3.
Please advise.
Kashif
