Count "Text" in a Textbox

[#1]

Hi,

I've got al Listbox

System | on_off

------------------------------

System3 | on

System1 | off

System33 | on

System78 | on

System133 | off

Now I want to crate a textbox where i can count all systems which are 'on'.

=count(on_off =1) & 'Systems are on'

Doesn't work, where is the problem??

Thanks

[#2]

Try it this way

=count(if(on_off=1, system))

You could count either column.

[swuehl · Accepted solution]

try either

= count(if (on_off = 'on', on_off)) & ' Systems are on'

or

=count({<on_off = {'on'}>} on_off) & ' Systems are on'

hope this helps,

Stefan