5 Replies Latest reply on Nov 24, 2017 9:21 AM by Deepak Rai

# IF NON EMPTY cell

Hi everybody,

How can write NON EMPTY cell ?

I want to calculate the following formula :  (number of "yes" in  a column / number of "yes" and "no" in the same column)

And in order to express "yes" and "no", i want to put NON EMPTY because sometimes cells are not filled.

Thank you soo much !!

Karim,

• ###### 1. Re: IF NON EMPTY cell

So I understand that you dont want to COUNT Nulls, But it is my guess. Can you attach a fake data set and explain what is needed to help u fast.

• ###### 2. Re: IF NON EMPTY cell

Yes, i want to calculate : nombre of yes / number of yes and no (without counting blanks)

• ###### 3. Re: IF NON EMPTY cell

Here is Result

I used this data, out of 11 cells , I have 9 Rows with data

 Answer Yes Yes Yes Yes No No No Yes No

Thanks

Deepak

1 of 1 people found this helpful
• ###### 4. Re: IF NON EMPTY cell

THANK YOU SO SO SO MUCH

YOU HELPED ME !!

Karim

• ###### 5. Re: IF NON EMPTY cell

You are Welcome!!!