SUMIFS XLOOKUP returns #VALUE! error - Githubissues

ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents

https://www.onlyoffice.com

Other

3k stars 338 forks source link

SUMIFS XLOOKUP returns #VALUE! error #1692

Closed cottontail-12 closed 1 month ago

cottontail-12 commented 1 month ago

This issue is unique.

[X] I have used the search tool and did not find an issue describing my bug.

Operating System

macOS 10.12 or higher

Version information

8.1.1

Expected Behavior

Sum a range of values. Where SUMIFS:

=SUMIFS(sum_range,criteria_range,criteria)

Using XLOOKUP to create a sum_range for the SUMIFS function:

=SUMIFS(XLOOKUP(lookup_value,lookup_array,return_array),criteria_range,criteria)

However, when SUMIFS contains XLOOKUP function, there is #VALUE! error.

Actual Behavior

Using XLOOKUP to create a sum_range for the SUMIFS function returns #VALUE! error.

SUMIFS XLOOKUP Screenshot

Reproduction Steps

=SUMIFS(XLOOKUP(lookup_value,lookup_array,return_array),criteria_range,criteria)

Additional information

Test Doc - sumifs xlookup.xlsx

Dmitry-Kov commented 1 month ago

Hi @cottontail-12, This issue is a duplicate. You can follow its resolution or ask additional questions here: https://github.com/ONLYOFFICE/DocumentServer/issues/2916