[Libreoffice-bugs] [Bug 130359] XLOOKUP() function

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130359

--- Comment #6 from Óvári <ovari123 at zoho.com> ---
Created attachment 157595
  --> https://bugs.documentfoundation.org/attachment.cgi?id=157595&action=edit
Example 6

Example 6
---------

This example uses the SUM function, and two XLOOKUP functions nested together
to sum all the values between two ranges. In this case, we want to sum the
values for grapes, bananas, and include pears, which are between the two.

The formula in cell E3 is:
=SUM(XLOOKUP(B3,B6:B10,E6:E10):XLOOKUP(C3,B6:B10,E6:E10))

How does it work? XLOOKUP returns a range, so when it calculates, the formula
ends up looking like this: =SUM($E$7:$E$9). You can see how this works on your
own by selecting a cell with an XLOOKUP formula similar to this one, then go to
Formulas > Formula Auditing > Evaluate Formula, and press the Evaluate button
to step through the calculation.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200202/1ed0a51b/attachment.htm>