SUBTOTAL Function Code doesn't accept cell reference

My spreadsheet accepts the function =SUBTOTAL(9,B11:B23) and properly returns a number value. However, when if cell E8 has a 9 and I write =SUBTOTAL(E8,B11:B23) I get a #VALUE! error. I was expecting the output of both functions to be the same.

1 Like

Thanks! We are tracking this internally as 004479. Will follow up on this thread when resolved.

1 Like

Issue ##004479 has been fixed with the latest upgrade

1 Like