Thank you jeffrey.
I should have explained myself better.
Here is how some of the actual model looks like:
Total
12
10
9
8
8
7
12
8
14
14
12
13
9
8
0
0
0
0
0
I want to count the amount of > 9.5 and < 9.5. I figured out how to do that.
My problem is that the last 5 entries of data haven't occured yet, so for now my calculations look like this:
Over 9.5: 7
Under 9.5: 12
When under 9.5 in reality should be 7.
So I would like to count the data without the blank/0 cells untill data is entered there.
If that makes in sense![]()
Bookmarks