ExcelBanter - SUBTOTAL and 9

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUBTOTAL and 9 (https://www.excelbanter.com/excel-discussion-misc-queries/246540-subtotal-9-a.html)

Jaleel

SUBTOTAL and 9

Hi,

In a table with subtotals we can see a formula like =SUBTOTAL(9,B4:B10)
irrespective of the number of rows. What is the importance of this "9"? Can
anybody explain?

Thanks & Regards,

Jaleel

Jacob Skaria

SUBTOTAL and 9

9 is the Function_num used to include hidden values...while doing SUM()

Syntax:
SUBTOTAL(function_num, ref1, ref2, ...)

Refer help on SUBTOTAL()

If this post helps click Yes
---------------
Jacob Skaria

"Jaleel" wrote:

Hi,

In a table with subtotals we can see a formula like =SUBTOTAL(9,B4:B10)
irrespective of the number of rows. What is the importance of this "9"? Can
anybody explain?

Thanks & Regards,

Jaleel

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