COUNTIF without counting blank cells

Hi Kasper & Welcome to the Board,

Given the example with the zeros what answer do you expect? If I take your example I get 3, 3 numbers greater than or equal to 9.5.

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

Oh, wow I'm really stupid. I thought that leaving a cell with a 0 and leaving it totally blank was the same

You can close this for now, I am gonna post something later when I have troubles with things.

Thanks

How about...

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