Студопедия
Случайная страница | ТОМ-1 | ТОМ-2 | ТОМ-3
АрхитектураБиологияГеографияДругоеИностранные языки
ИнформатикаИсторияКультураЛитератураМатематика
МедицинаМеханикаОбразованиеОхрана трудаПедагогика
ПолитикаПравоПрограммированиеПсихологияРелигия
СоциологияСпортСтроительствоФизикаФилософия
ФинансыХимияЭкологияЭкономикаЭлектроника

Basic functions : SUBTOTAL

Ranking and sorting data I | Conditional summation revisited | Regression analysis I : Basic linear formulas | Regression Analysis II : Basic functions, charting | Regression Analysis III : LINEST | Combining data in cells | Date & Time : Calculating Dates of Holidays | Financial Functions 3 : Complex Accumulation | Data Consolidation 101 | Basic Functions: FREQUENCY |


Читайте также:
  1. Advanced Functions: INDIRECT
  2. Basic Functions : CELL
  3. Basic Functions : FIXED
  4. Basic functions : SUMIF
  5. Basic Functions: FREQUENCY
  6. Basic structures

March 2nd, 2005

n SUBTOTAL function allows you to perform basic spreadsheet operations on the visible cells in AutoFilter mode.


In the example below, we have sales figures for 4 salesmen - George, Paul, Ringo and John.

After we apply the AutoFilter to display only the sales related to Paul, we use SUBTOTAL as shown to average his sales.

The SUBTOTAL function takes two arguments:

SUBTOTAL(function; range)

Function is a number that stands for one of the following functions:

1 AVERAGE
2 COUNT

3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP

If you do not wish to use AutoFilter, you can use a combination of SUMIF and COUNTIF as shown below to achieve the same results - at least as far as averaging is concerned.


Дата добавления: 2015-08-03; просмотров: 52 | Нарушение авторских прав


<== предыдущая страница | следующая страница ==>
Advanced Functions: INDIRECT| Filling a Cell Range with a Series

mybiblioteka.su - 2015-2024 год. (0.005 сек.)