SUMIFS no longer working in some situations

[nicojx]

This issue is unique.

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

Operating System

Linux (DEB package) (actually, I use the Flatpak)

Version information

8.2.2.22

Expected Behavior

I use a long-ish SUMIFS formula:

=-SUMIFS($D:$D,$D:$D,"<0",$F:$F,$I2,$B:$B,">="&M$1,$B:$B,"<="&EOMONTH(M$1,0),$C:$C,"<>"&"Redistributing")

on a table with the headings (B:F) Date, Description, Amount, Balance, Category.

	B	C	D	E	F
1	Date	Description	Amount	Balance	Category
2	13/1/2024	Item	-99	200	Cat1
3	14/1/2024	Item	98	300	Cat1
3	1/2/2024	Item	-88	300	Cat1
3	14/1/2024	Item	-77	300	Cat2
3	14/1/2024	Item	-22	300	Cat3

I used this formula in a summary table such as

I	J	K	L	M	N
				1/1/2024	1/2/2024
Cat1				(formula)	(formula)
Cat2				(formula)	(formula)

This formula used to work fine, giving me a conditional sum of Amount, taking account of Date and Category, and only adding Amount if it is negative, resulting in:

I	J	K	L	M	N
				1/1/2024	1/2/2024
Cat1				99	88
Cat2				77	0

Actual Behavior

Now I get #VALUE errors. These disappear if I remove any one set of conditions (i.e. two corresponding arguments) or of the total sum is zero because at least one of the conditions is not fulfilled.

Reproduction Steps

Reproduction: paste the tables into a new workbook, and the formula into M2 and drag across.

Additional information

Not sure if this is strictly a DesktopEditors issue, I tried the same on Nextcloud OnlyOffice (with the latest Community Server) and the issue is the same. These formulas definitely used to work at some point.