. : http://uneex.lorien.cs.msu.su/static/GnumericDoc_ru/r8403.html
: Mon Sep 26 12:35:55 2011
: Tue Oct 2 08:07:46 2012
: IBM-866
:
SUBTOTAL
úº ̺º Gnumeric
PrevNext

SUBTOTAL

Name

SUBTOTAL -- 

Synopsis

SUMIF(function_nbr,ref1,ref2,...)

Description

ɺ̺ SUBTOTAL Ǻغú ʺǶͶúѶǺӶɺڶ ̺ѶǶ ºɶɶǶ ʶ̺ ͶöɺѶǶ. @function_nbr - ɶǶͶú, ǺѶǺڶ 溧ڶú Ժɺ̺ ̺ʶǶȺۺǶѺ ¶Ⱥ ںӶ̺ȶöɶ̺. ǺѺʶɺ ȶöºݺض̶ Ժɺ̶:

1 AVERAGE

2 COUNT

3 COUNTA

4 MAX

5 MIN

6 PRODUCT

7 STDEV

8 STDEVP

9 SUM

10 VAR

11 VARP

Ѻ Ժɺ̺ ǶͶúѶ̶ͺ Excel.

Examples

ǶʺѶ̶, ӺѶ ޺Ӷö˺ A1, A2, ... A5 Ƕ¶ú Ӷ̺Ⱥ 23, 27, 28, 33 39. Ƕº

SUBTOTAL(1,A1:A5) equals 30.

SUBTOTAL(6,A1:A5) equals 22378356.

SUBTOTAL(7,A1:A5) equals 6.164414003.

SUBTOTAL(11,A1:A5) equals 30.4.

See also

COUNT, SUM.

PrevHomeNext
SUBSTITUTEUpSUM