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.