OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: Fwd: Forced Array Example





-------- Forwarded Message --------
Subject: Forced Array Example
Date: Sun, 3 Dec 2017 17:45:12 -0500
From: Patrick Durusau <patrick@durusau.net>
To: ODF TC List <office@lists.oasis-open.org>


Greetings!

To follow up on our discussion last week of

 https://issues.oasis-open.org/browse/OFFICE-3905 LINEST and LOGEST and Force Array.

Visit: https://help.libreoffice.org/Calc/Array_Functions

Look for: 

Conditional Array Calculations, which has this example:

A 1 B (formula) =A1:A2+1 B (result) 2 C (forced array formula) =SUMPRODUCT(A1:A2+1) C (result) 5

A 2 B (formula) =A1:A2+1 B (result) 3 C (forced array formula) =SUMPRODUCT(A1:A2+1) C (result) 5

MS Excel example:

https://www.techonthenet.com/excel/formulas/sumproduct.php

Latest office product help:

https://support.office.com/en-us/article/SUMPRODUCT-function-16753e75-9f68-4874-94ac-4d2145a2fd2e

Does that help? Jos?

Hope everyone is at the start of a great week!

Patrick

PS: I will test it tonight but all I need to do in the short term to fix my phone issues is to run a VM that then runs Skype, ahem, on a different OS. ;-)
-- 
Patrick Durusau
patrick@durusau.net
Technical Advisory Board, OASIS (TAB)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)

Another Word For It (blog): http://tm.durusau.net
Homepage: http://www.durusau.net
Twitter: patrickDurusau 

Attachment: signature.asc
Description: OpenPGP digital signature



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]