| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF Subtotal Function? | Excel Discussion (Misc queries) | |||
| Cannot Reference "Array" in Subtotal Function | Excel Worksheet Functions | |||
| Nested --- Subtotal IF function | Excel Worksheet Functions | |||
| Subtotal function with Filtered Data | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Linear Mode
