Sum(children()) with filter or in reports

Peter

Hi there,

is it possible to get the sum or count of a filtered sheet or in a report? 

I want to know how many lines are filled with data. I use the count(children()) function. In one cell are the nicks of the employees (like "KOV, SEA, KEP ..."). Now I set a filter that only shows me lines where "KEP" is in this string. In the parent line should the number of lines appear ...

without filter:

filtered "HUJ" (the number should change to less than 17):

many thanks

Peter

 

 

Kyle Clopton

As far as I know, a formula will include values of filtered data. A filter doesn't remove data it simply hides it from view. A quick test adding numbers in a column returned a value of 14. When I filtered a few of the numbers out, the value of the formula was still 14. Perhaps you could use a checkbox column that included a formula that if the test was positive, would check the box. Then create an additional formula that summed the number of check boxes. 

Peter

many thanks ... got the same result which is not good ...