| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal Formula
Hi! ;)
When subtotals have been created in an excel file - when viewing the formula in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23) -- Thanks, Pat |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotal Formula
Believe it or not, the "9" stands for SUM. See table below for other possible
choices: 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP "Pat" wrote: Hi! ;) When subtotals have been created in an excel file - when viewing the formula in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23) -- Thanks, Pat |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotal Formula
The SUBTOTAL function is multipurpose.....
The first argment value tells it what kind of value to return: Num Function 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP In your case.....9 returns a SUM Does that help? *********** Regards, Ron XL2002, WinXP "Pat" wrote: Hi! ;) When subtotals have been created in an excel file - when viewing the formula in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23) -- Thanks, Pat |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotal Formula
It is all explained in the help file for the SUBTOTAL function,
9 stands for SUM, 2 for COUNT and so on -- Regards, Peo Sjoblom "Pat" .(donotspam) wrote in message ... Hi! ;) When subtotals have been created in an excel file - when viewing the formula in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23) -- Thanks, Pat |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotal Formula
OK, in my subtotal formula what would 103 and 109 stand for?
=SUBTOTAL(103,A1:A6148 =SUBTOTAL(109,A1:A6148 "Peo Sjoblom" wrote: It is all explained in the help file for the SUBTOTAL function, 9 stands for SUM, 2 for COUNT and so on -- Regards, Peo Sjoblom "Pat" .(donotspam) wrote in message ... Hi! ;) When subtotals have been created in an excel file - when viewing the formula in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23) -- Thanks, Pat |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotal Formula
COUNTA and SUM, but these will not only sum or count visible cells from
filtering they will do it for hidden cells as well. These were introduced in Excel 2003 and they just added 100 to the previous subtotal. It's in help as well -- Regards, Peo Sjoblom "Carla" wrote in message ... OK, in my subtotal formula what would 103 and 109 stand for? =SUBTOTAL(103,A1:A6148 =SUBTOTAL(109,A1:A6148 "Peo Sjoblom" wrote: It is all explained in the help file for the SUBTOTAL function, 9 stands for SUM, 2 for COUNT and so on -- Regards, Peo Sjoblom "Pat" .(donotspam) wrote in message ... Hi! ;) When subtotals have been created in an excel file - when viewing the formula in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23) -- Thanks, Pat |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotal Formula
Can you tell me exactly where in help this list would be? I can't seem to
find it. "Peo Sjoblom" wrote: COUNTA and SUM, but these will not only sum or count visible cells from filtering they will do it for hidden cells as well. These were introduced in Excel 2003 and they just added 100 to the previous subtotal. It's in help as well -- Regards, Peo Sjoblom "Carla" wrote in message ... OK, in my subtotal formula what would 103 and 109 stand for? =SUBTOTAL(103,A1:A6148 =SUBTOTAL(109,A1:A6148 "Peo Sjoblom" wrote: It is all explained in the help file for the SUBTOTAL function, 9 stands for SUM, 2 for COUNT and so on -- Regards, Peo Sjoblom "Pat" .(donotspam) wrote in message ... Hi! ;) When subtotals have been created in an excel file - when viewing the formula in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23) -- Thanks, Pat |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotal Formula
Do you have Excel 2003 or later? Just look up SUBTOTAL in help (comes up as
SUBTOTAL worksheet function) -- Regards, Peo Sjoblom "Carla" wrote in message ... Can you tell me exactly where in help this list would be? I can't seem to find it. "Peo Sjoblom" wrote: COUNTA and SUM, but these will not only sum or count visible cells from filtering they will do it for hidden cells as well. These were introduced in Excel 2003 and they just added 100 to the previous subtotal. It's in help as well -- Regards, Peo Sjoblom "Carla" wrote in message ... OK, in my subtotal formula what would 103 and 109 stand for? =SUBTOTAL(103,A1:A6148 =SUBTOTAL(109,A1:A6148 "Peo Sjoblom" wrote: It is all explained in the help file for the SUBTOTAL function, 9 stands for SUM, 2 for COUNT and so on -- Regards, Peo Sjoblom "Pat" .(donotspam) wrote in message ... Hi! ;) When subtotals have been created in an excel file - when viewing the formula in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23) -- Thanks, Pat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Help with SUBTOTAL formula | Excel Worksheet Functions | |||
| Need a simple subtotal Formula | Excel Worksheet Functions | |||
| Nested Subtotal Formula | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
![Pat[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
