In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

Must be

=AANTAL.ALS(A1:A10;WAAR)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Use it like this

=COUNTIF(A1:A10,TRUE)

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

And all your TRUE's are Waar in the Cells so the formula still work


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trevor Williams" wrote in message
...
Dear All

What happens to TRUE/FALSE responses if a workbook created on an English
language pc is used on another langauge pc? - particularly in formulae e.g.

=COUNTIF(A1:A10,"=true")

Does the workbook remain in the English language, or convert to the local
language?

Thanks

Trevor Williams