SUBTOTAL

Ð ÑƒÐºÐ¾Ð²Ð¾Ð´ÑÑ‚Ð²Ð¾ Ð¿Ð¾Ð»ÑŒÐ·Ð¾Ð²Ð°Ñ‚ÐµÐ»Ñ Gnumeric
Prev		Next

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.

SUBTOTAL

Name

Synopsis

Description

Examples

See also