Description: When using one of the mentioned functions with a range, that is constructed over multiple sheets (e.g. ```=SUMIF(Sheet1.A1:Sheet2.A1,">0" )``` ) there is an error in the parameter. In the case of SUMIF, the same syntax is working when the range is on a single sheet (e.g. A1:B1) or when using SUM instead. Steps to Reproduce: 1.Creat new Document with 2 Sheets 2.Fill Cell with: =SUMIF(Sheet1.A1:Sheet2.A1,">0" ) Actual Results: Err:504 Reproducible: Always User Profile Reset: No Additional Info: Version: 25.8.1.1 (X86_64) / LibreOffice Community Build ID: 580(Build:1) CPU threads: 6; OS: Linux 6.16; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US 25.8.1-2 Calc: threaded
That is not a bug,oOnly a few functions support that kind of ranges: SUM, AVERAGE, COUNT, MAX, MIN, PRODUCT. As I know, none of the conditional functions works with 3d ranges. I think there is bug asking for their implementation, but I can't find it now.
(In reply to m_a_riosv from comment #1) > That is not a bug,oOnly a few functions support that kind of ranges: > SUM, AVERAGE, COUNT, MAX, MIN, PRODUCT. > > As I know, none of the conditional functions works with 3d ranges. > > I think there is bug asking for their implementation, but I can't find it > now. I guess you mean bug 168236
(In reply to Xisco Faulí from comment #2) > (In reply to m_a_riosv from comment #1) > > That is not a bug,oOnly a few functions support that kind of ranges: > > SUM, AVERAGE, COUNT, MAX, MIN, PRODUCT. > > > > As I know, none of the conditional functions works with 3d ranges. > > > > I think there is bug asking for their implementation, but I can't find it > > now. > > I guess you mean bug 168236 Looks similar, working with cube (3d) ranges. I remember a comment about this matter from @Eike somewhere, but I'm unable to find it. If you think it can be resolved in the same way, please mark it as dupe.