Changes

=SUBTOTAL(SomeType, SomeArray)=

<div style="font-size:30px">'''SUBTOTAL (Type,Arrays)'''</div><br/>

 

where,

where,

*<math>SomeType</math> specifies which function type to use within a list,

*<math>Type</math> specifies which function type to use within a list,

*<math>SomeArray</math> is set of values or range of cells containing values.

*<math>Arrays</math> is set of values or range of cells containing values.

SUBTOTAL() calculates a subtotal in a list or database.

SUBTOTAL(), returns a subtotal in a list or database.

== Description ==

== Description ==

SUBTOTAL(SomeType, SomeArray)

SUBTOTAL(Type, Arrays)

*SUBTOTAL() function is designed for columns of data or vertical range of cells.

*SUBTOTAL() function is designed for columns of data or vertical range of cells.

*Argument <math>SomeType</math> specifies which function to use in calculating subtotal from the list of functions. <math>SomeType</math> can be any number between 1 to 11 (that includes hidden values) or 101 to 111 (that ignores hidden values).

*Argument <math>Type</math> specifies which function to use in calculating subtotal from the list of functions. <math>Type</math> can be any number between 1 to 11 (that includes hidden values) or 101 to 111 (that ignores hidden values).

*Below table describes the Function Type and the number associated with it.

*Below table describes the Function Type and the number associated with it.

{| class="wikitable"

{| class="wikitable"

|}

|}

*<math>SomeArray</math> is an array of values or reference to cells containing values, for which the subtotal is to be calculated.

*<math>Arrays</math> is an array of values or reference to cells containing values, for which the subtotal is to be calculated.

*Text values or empty cells are ignored.

*Text values or empty cells are ignored.

*For invalid argument values, Calci displays an error message.

*For invalid argument values, Calci displays an error message.