COUNT only visible rows in specific VIEW

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?

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.


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