I have a questionnaire that is written in excel and I need to convert a formula to open office. The formula is =COUNTIF(D1:D45,"Yes")/MAX(1,SUM(COUNTIF(D1:D45,{"Yes","No"})))

I get a #Name? error on open office when i copied and pasted the formula.

I have about 45 questions that can be answered yes, no or n/a. I need to know the percentage.

thanks