Steps to Reproduce
1. import the attached file
Current Result
A14 shows 9
Expected Result
A14 shows 1
Debug Information
- A14 shows 1 in Excel because only A2 is visible.
- subtotal 109 should conform to https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939?redirectSourcePath=%252fen-US%252farticle%252fSUBTOTAL-function-e27c301c-be9a-458b-9d12-b9a2ce3c62af&ui=en-US&rs=en-US&ad=US
- relates to
-
ZSS-962 SUBTOTAL function should suport ignore hidden cell for subfunction 101 to 111
-
- Closed
-
-
KEIKAI-263 SUM() should not exclude hidden cells by a filter
-
- Closed
-