SUBTOTAL and 9

  • Thread starter Thread starter Jaleel
  • Start date Start date
J

Jaleel

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional SUBTOTAL in XL210 Table 7
Getting Text data using the Data - Subtotal feature 1
Combine Sumif and Subtotal 4
ABS in SUBTOTAL 3
Conditional subtotal 10
Can you use math functions as arguments in a subtotal formula? 3
Totaling Subtotals 2
Continuous Invoice Nos. 3

Back
Top