Hi,
I am trying to build a model, but I have some problems.
Say I have a row with data, like:
Total:
12
10
8
5
12
5
ect....
I want to count how many of the numbers are > 9.5.
I used this formula: =COUNTIF(F4:F22;">=9,5") , and it works fine.
However, there is some missing data, that is gonna get added on the way. Like a bunch of blank/0 cells. Looks like this:
Total:
12
10
8
5
12
5
0
0
0
0
0
ect....
Is there any way to add something to the COUNTIF formula to exclude the blank cells from being counted?
Any help is appriciated.
Kasper
Bookmarks