COUNTIF without counting blank cells

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

How about...

=SUMPRODUCT(--($A$1:$A$19<9.5),--($A$1:$A$19>0))