IF Formula Help

[ac520]

Hi! Can someone help me put together a string of multiple IF formulas? 

See the table below. 

I want the Progress Column to show the percentages associated with what is filled in for the Status columns. 

For example, if Column D has any value in it, then Column C (Progress) will show 10%

If Column D+E have any values, then Column C (Progress) will show 20%

If Column D+E+F have any values, then Column C (Progress) will show 30%

If Column D+E+F+G have any values, then Column C (Progress) will show 40%

If Column D+E+F+G+H have any values, then Column C (Progress) will show 50%

If Column D+E+F+G+H+I have any values, then Column C (Progress) will show 65%

If Column D+E+F+G+H+I+J have any values, then Column C (Progress) will show 90%

If Column D+E+F+G+H+I+J have any values, then Column C (Progress) will show 100%

[#2]

@ac520 

As variant

=CHOOSE( COUNTA(D3:K3), 10%, 20%, 30%, 40%, 50%, 65%, 90%, 100% )

and drag it down

[#3]

@ac520 

The anomalies in the rounding make this one a bit longer but here goes:

=LET(
    n, COLUMNS(matrix),
    filled, (LEN(matrix) <> 0) * 1,
    multiplier, SEQUENCE(n, , 1, 0),
    m, MMULT(filled, multiplier),
    SWITCH(m, 6, 0.65, 7, 0.9, 8, 1, m / 10)
)