Apache OpenOffice Community Forum

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

Calc supports the same function list as Excel, but the separator is ; and not ,. One easy way to d this conversion is to open an XLS with the formulas in it in OOo Calc and the conversion will get on automatically on load.

Also I've had problems getting inline lists to work, so I tend to use regular expressions (which can be enabled through Tools - Options - OpenOffice.org Calc - Calculate), hence the formula becomes
=COUNTIF(D1:D45;"Yes")/MAX(1;SUM(COUNTIF(D1:D45;"(Yes|No)")))

[Moved new question to it's own new topic: http://user.services.openoffice.org/en/ ... =32&t=1362]