I'm looking at cells in P215-W215.
I want to exclude cells if the contain
1 space
2 spaces
3 spaces
4 spaces
5 spaces
a "0"
or the words "n/a" anywhere in the cell.
I want to count all other cells. So for row 1 in the pic, it should return 5
For row 2 in the pic it should return 4
For row 3 it should return 6
The empty cell is picking up data, it looks blank but it contains any number of spaces, so I want to exclude it from the count
I have this formula, but it's so messy and not doing what I want it to.
=((COUNTIF(P51:W51,"*"&"")))-((COUNTIF(U51," ")+COUNTIF(U51," ")+COUNTIF(U51," ")+COUNTIF(U51," ")+COUNTIF(U51," "))+(COUNTIF(U51," ")+COUNTIF(V51," ")+COUNTIF(V51," ")+COUNTIF(V51," ")+COUNTIF(V51," "))+(COUNTIF(W51," ")+COUNTIF(W51," ")+COUNTIF(W51," ")+COUNTIF(W51," ")+COUNTIF(W51," "))+(COUNTIF(P51," ")+COUNTIF(P51," ")+COUNTIF(P51," ")+COUNTIF(P51," ")+COUNTIF(P51," "))+(COUNTIF(Q51," ")+COUNTIF(Q51," ")+COUNTIF(Q51," ")+COUNTIF(Q51," ")+COUNTIF(Q51," "))+(COUNTIF(R51," ")+COUNTIF(R51," ")+COUNTIF(R51," ")+COUNTIF(R51," ")+COUNTIF(R51," "))+(COUNTIF(S51," ")+COUNTIF(S51," ")+COUNTIF(S51," ")+COUNTIF(S51," ")+COUNTIF(S51," "))+(COUNTIF(T51," ")+COUNTIF(T51," ")+COUNTIF(T51," ")+COUNTIF(T51," ")+COUNTIF(T51," ")))
I want to exclude cells if the contain
1 space
2 spaces
3 spaces
4 spaces
5 spaces
a "0"
or the words "n/a" anywhere in the cell.
I want to count all other cells. So for row 1 in the pic, it should return 5
For row 2 in the pic it should return 4
For row 3 it should return 6
The empty cell is picking up data, it looks blank but it contains any number of spaces, so I want to exclude it from the count
I have this formula, but it's so messy and not doing what I want it to.
=((COUNTIF(P51:W51,"*"&"")))-((COUNTIF(U51," ")+COUNTIF(U51," ")+COUNTIF(U51," ")+COUNTIF(U51," ")+COUNTIF(U51," "))+(COUNTIF(U51," ")+COUNTIF(V51," ")+COUNTIF(V51," ")+COUNTIF(V51," ")+COUNTIF(V51," "))+(COUNTIF(W51," ")+COUNTIF(W51," ")+COUNTIF(W51," ")+COUNTIF(W51," ")+COUNTIF(W51," "))+(COUNTIF(P51," ")+COUNTIF(P51," ")+COUNTIF(P51," ")+COUNTIF(P51," ")+COUNTIF(P51," "))+(COUNTIF(Q51," ")+COUNTIF(Q51," ")+COUNTIF(Q51," ")+COUNTIF(Q51," ")+COUNTIF(Q51," "))+(COUNTIF(R51," ")+COUNTIF(R51," ")+COUNTIF(R51," ")+COUNTIF(R51," ")+COUNTIF(R51," "))+(COUNTIF(S51," ")+COUNTIF(S51," ")+COUNTIF(S51," ")+COUNTIF(S51," ")+COUNTIF(S51," "))+(COUNTIF(T51," ")+COUNTIF(T51," ")+COUNTIF(T51," ")+COUNTIF(T51," ")+COUNTIF(T51," ")))