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

Conditional summation revisited

Using Pop Up Notes in Cells | Macros: Text Utilities Part I | Adding a dialog: Part I | Adding a dialog: Part II | Formatting ratios | Filling a multiplication chart | Spelling out numbers | Datapilot Revisited | DataPilot Revisited II | Regression Analysis II : Basic functions, charting |


Читайте также:
  1. Datapilot Revisited
  2. DataPilot Revisited II

April 20th, 2005

For OOo 2.0, enhanced functionality seems to have been introduced with respect to using array formulas for conditional summation. Consider the example below, where we wish to total numbers in a column corresponding to a particular month.

Contrast this with the use of SUMIF in a previous tip. We have also covered SUMPRODUCT before

Now, the SUM IF and SUMPRODUCT constructs shown below accept a function of an array. MONTH normally accepts a single date as a parameter - but within an array formula as in the examples below, it makes more sense to be able to apply an array of dates to MONTH. This has always been possible in Excel.

It seems, OOo Calc continues to match and/or surpass Excel in functionality - which can onloy be a good thing for those who wish to migrate from Excel.

Posted in Function Tips | No Comments»


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


<== предыдущая страница | следующая страница ==>
Ranking and sorting data I| Regression analysis I : Basic linear formulas

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