Need help adapting a formula

[mattbird]

Hi,

I'm currently producing an attendance list and recording a rolling percentage. I am using the following formula:

=IF(COUNTIFS($D11:$O11,"")=12,0,SUM(COUNTIFS($D11:$O11,{1,"D"}))/$U11) - inputted in cell V11 of table.

The formula work, but I would like to adapt it.

My table has the following key:

1 = attended ( this is counted in cell P11)
0 = did not attend (this is counted in cell S11)
A = Apologies (this is counted in cell R11)
D = Deputy (this is counted in cell Q11)

In cell U11 I have a sum to add P11:S11, which give me a total for the formula above.

I have added a new cell T11 which counts 'N' (not required) when placed in any cell D11:O11 and I don't want 'N' to affect the percentage. If all the cells D11:O11 are empty and I place an 'N' in any of them cells my percentage cell V11 returns #DIV/0! when I need it to show 0%.

example 1:

Cell: D11 E11 F11 G11 H11 I11 J11 K11 L11 M11 N11 O11 V11 (formula cell)
input: 1 100%

example 2:

Cell: D11 E11 F11 G11 H11 I11 J11 K11 L11 M11 N11 O11 V11 (formula cell)
input: 1 1 100%

example 3:

Cell: D11 E11 F11 G11 H11 I11 J11 K11 L11 M11 N11 O11 V11 (formula cell)
input: 1 0 50%

example 4:

Cell: D11 E11 F11 G11 H11 I11 J11 K11 L11 M11 N11 O11 V11 (formula cell)
input: 1 N 100%

example 5:

Cell: D11 E11 F11 G11 H11 I11 J11 K11 L11 M11 N11 O11 V11 (formula cell)
input: N 1 100%

However,

example 6:

Cell: D11 E11 F11 G11 H11 I11 J11 K11 L11 M11 N11 O11 V11 (formula cell)
input: N #DIV/0! would like it to show 0%

How do I change the formula to not see N, if you understand what I mean.

I hope this make sense, as it hard to explain.

 

[shift-del]

Hi

IFERROR(your_formula,0)

 

[mattbird]

Hi

IFERROR(your_formula,0)

Thanks, that works perfectly. I did try the IFERROR, however I put the 0 in the wrong place.