FORMULA Help please

[ashani]

Hi,

I'm using the below formula - the outcome should be that if all N/A - then ignore, if all Yes then then 0 and if any No then count number of Nos. However it's working in the other cells but some cells are merged and it's not working, please can someone guide me on this.

=IF(IF(COUNTIF(F32:T32,"N/A")=COUNTA(F32:T32)+COUNTBLANK(F32:T32),1,0)=1,"",IF(COUNTBLANK(F32:T32)>0,"",COUNTIF(F32:T32,"No")))

Many thanks

 

[ER_Neha]

Hi,

Can you share the data table you are looking to modify via xl2bb.
It will be easier to understand your requirement then.

Thanks

 

[CA_Punit]

First of all, why you need such a big formula

If you use countif(F32:T32,"No") then automatically all conditions are satisfied,

I,e if all are yes then it will show 0 and if all are #Na even then it will show 0. (However if you require null string in case of #Na then can consider)

Merged cell is an issue. But as I can understand you are applying the formula in a single cell. Do you mean cell in the range F32:T32 is merged or the cell in which you are entering the formula is merged????

 

[Fluff]

Cross posted Merge Cells formula

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.