Forum Discussion

Copper Contributor

Jan 10, 2022

Please tell me what I am doing incorrectly-Excel SUBTOTAL Function 9 and 109 return the same Results

A Spreadsheet, created using macOS Numbers, was opened in Excel because it offers a wide range Of Functions, and the ability to Hide Cell Content seemed an ideal choice for the project in hand. So I...

microsoft 365

Gelphyn

Copper Contributor

Jan 12, 2022

Needing to progress this matter to, if it becomes necessary, cancel my 365 Subscription before the Trial Month expires it has been reported via the In App Feedback system.

A Link to this Thread has been included in my Feedback and not wishing to waste anyones time include details of the Software involved.

My MacBook Pro 2020 M1 is running macOS Monterey Version 12.1

Excel is Microsoft® Excel for Mac Version 16.56 (21121100) Licence: Microsoft 365 Subscription

Hopefully I have now included all the information that may be needed. Please feel free to inform if there is anything else required. Thank you.

Steve_K_Excel

Former Employee

Jan 13, 2022

Gelphyn From looking at the workbook, there are values in the cells for the "V" rows, but the format causes the value to not be visible. The Excel SUBTOTAL function does not consider these to be hidden, since the rows are not hidden. If you use a filter to filter out the "V" rows, they will be hidden and the subtotal result should be as expected. You could also hide the rows by right-clicking on the row number and choosing "Hide".