AutoFilter and Subtotal (differences in the result by calling the way)

Please Login or Register  to view this content.

-->Call from another sheet（=CountMember(1,1)) --> Result 13

Please Login or Register  to view this content.

--> Result 3 (Ideal of value)


Above there is the way the two calls.
I'm looking for the cause of the result is different.


Table"live_area" in Sheet "students"

Please Login or Register  to view this content.

Have you tired

Please Login or Register  to view this content.

Originally Posted by jindon

Have you tired

Please Login or Register  to view this content.

I see. Thank you.