COUNT only visible rows in specific VIEW

❓ Questions & help 𝑓x Formulas
1

I use COUNTA to count the number of persons in dataset. I have different views where only subgroups of the whole dataset are displayed and would like to count the number of persons (rows) there. How could I do that?

2

Hi @Urs ,

Subtotal function can solve your use case.
Just define a subtotal say “=subtotal(function_code,range)” (In your case: function_code should be 3 for COUNTA) in a primary view and whenever we switch to another view, it will fetch the values based on the rows which are visible.

Please find the below link for the reference.

Thanks.

3

Thanky you so much Kiran for your swift reply! Works perfectly. You really saved my day :sunny:

2 Likes