ExcelBanter - Subtotal Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Subtotal Function (https://www.excelbanter.com/excel-worksheet-functions/94776-subtotal-function.html)

ktenold

Subtotal Function

Why would the subtotal function delete the end of a worksheet? In other words
why would it not subtotal the entire worksheet and only a portion?

CLR

Subtotal Function

If you are refering to the SUBTOTAL worksheet function, then it calculates to
the Range specified therein. If you have what appear to be numbers within
the specified range which do not calculate, then they are probably formatted
as TEXT rather than numbers and just "look" like numbers.

Vaya con Dios,
Chuck, CABGx3

"ktenold" wrote:

Why would the subtotal function delete the end of a worksheet? In other words
why would it not subtotal the entire worksheet and only a portion?

All times are GMT +1. The time now is 11:51 AM.