Question about the count-function

[#1]

Hi,

I want to count all rows of an column where the value is 1. I have tried it with the count-function:

count(column(2)=1)

But it shows me just the number of all rows of the column. How can I create a formula that shows me the right value?

Thank you for your help.

[martinpohl]

Hello,

the problem is that the result of column(2) is in each line.

So if you want to count where do want to count?

In the title of the chart? In a textbox?

Regards.

[#3]

I have got a table and I want the result in a diagram.

[#4]

Maybe this won't fit your requirements if its grander than your example but a simple fix could be within your script.

If(column2=1,1,0) as Column2_1Count

then sum(Column2_1Count)

[#5 · Accepted solution]

Sum(if((column(2)=1,1,0)