Skriver frågan på engelska. Hoppas någon kan hjälpa mig med detta och visa hur formeln ska se ut.
Tack på förhand! God Jul och Gott Nytt År!

Hello, Been trying to make the following.

Key: x=finished, n=negligible

Project
Task1
Task2
Task3

So no matter the combination, if n is in, it should be excluded.
For example:
Task1 x Result: 50%
Task2 blank
Task3 n

The result should be 50% but I get 100%...and if it were 2 n and one x it should be 100%.

Been using the following formulas without success
COUNTIF(C29:C30;"x")/COUNTA(C29:C30)
COUNTIF(!$C$49:$C$50;"x")/COUNTA($C$49:$C$50)-IF(!$C$49="n";"-0,25")-IF(!$C$50="n";"-0,25")

Hopefully someone can help me!
Best regards