<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - XLOOKUP() function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130359#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - XLOOKUP() function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130359">bug 130359</a> from <a class="email" href="mailto:ovari123@zoho.com" title="Óvári <ovari123@zoho.com>"> Óvári</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=157595" name="attach_157595" title="Example 6">attachment 157595</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=157595&action=edit" title="Example 6">[details]</a> 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>