Countif/counta?

[The Grim Discovery]

Hello people

In my lovely worksheet cells A1:A10 can either be blank, contain a date or contain a "no".
I'm trying to work out a formula that will allow me to calculate the % of non-blank cells that do not contain a "no". I've tried dividing countifs of no by countifs of<>no and dividing countifs by counta but I cant get it. Could someone help? THanks in advance.

 

[RoryA]

Dividing Countif(range,"no") by COUNTA(range) should work - assuming that the blank cells are actually empty.

 

[The Grim Discovery]

Cheers Rory. But I'm still having issues with this - and the cells are blank as far as I can tell. (I've cleared contents, deleted, etc)

=COUNTIF(Range,"No")/COUNTA(Range)%

works fine in terms of counting "no" across the specified range. Four of the cells are non-blank and of these three contain "no" giving a total of 75%.
But I need to know the responses that aren't "no" which here should be 25%. So I modify the formula to:

=COUNTIF(E12:N12,"<>No")/COUNTA(E12:N12)%
But this is giving me a total of 175% not the 25% i'm expecting. Any clue?
As ever thanks in advance.

 

[Aladin Akyurek]

Does this work for you?

=COUNT(range)/(COUNT(range)+COUNTIF(range,"?*"))

If not, you can perhaps post a sample along with the result that you expect from that sample.

 

[RoryA]

=COUNTIF(E12:N12,"<>No")/COUNTA(E12:N12)%
But this is giving me a total of 175% not the 25% i'm expecting. Any clue?

The blue part will also count blank cells.

Given that you already have the 75% calculated, why not just subtract that from 1 for your second result?