Hi,

I have a countif that looks like :

=COUNTIF(L4:L48, "Yes")/(COUNTA(L4:L48)-COUNTIF(L4:L48, "n/a"))

Basically, this works out the percentages of Yes compared to No.

What I need now is to add an extra layer to this formula that will only count the yes' where the value in the F column of that row = 0.

Any idea? Every IF statement I try comes out with #Value??