Adding Percentage score to e-mail

[warp765]

Hi All

I have a macro for sending feedback e-mails to users. I need to add a new line into the e-mail body to give a quality score.

For each unique UserID in ColA the score calculation will be: Count ColJ that equals "N/A" / Total Count *100.

I'd like to add the percentage into the 'Quality' string in the e-mail body. Many thanks for any help!

NOTE: The html code causes a firewall problem when posting so the existing code is in the attached sheet.

[oeldere]

N2 =IFERROR((IF(Countif($A$2:$A55,$A2)=Countif($A$2:$A2,$A2),($A$2:$A55,$A2),"")/Counta($A$2:$A$55)),"") and drag down.

Format as %.

I can't help you adding this in the body of the file.