Created attachment 129592 [details] Issue showing issue with sumifs What happens: If you have a sumifs with as an example 2 criteria and one if left blank both in the criteria and the range, this will not sum up. Expected behaviour: The sumifs should sum up even if blank cells when both the criteria and range contains a blank value. Seems that the function always will have to have a value to sum in sumifs. How to test: 1. In an empty spreadsheet we enter columns with Index Index 1 a 10 1 a 10 2 b 11 2 b 11 2 c 12 2 c 12 2 d 13 2 d 13 4 e 14 4 e 14 5 f 15 5 f 15 6 g 16 6 g 16 7 h 17 7 h 17 8 0 8 18 2. In column B enter the formula: =SUMIFS(F$2:F$10,D$2:D$10,A2,E$2:E$10,B2) 3. Copy it down. 4. In row 8 no value is summed in column B which is due to B/8 and E/8 are left blank. Expected value 18. Test sheet attached.
A blank cell it's not the same than an empty string, B2 it's used as zero, you can force an empty string with a formula like: =SUMIFS(F$2:F$10,D$2:D$10,""&A10,E$2:E$10,""&B10) that works for me. You can test your formula putting a zero on E8.
Could you please explain why this is implemented like this? You are comparing 2 cells which are identical in this case blank and I expected it to return the value. Your workaround is solving the issue, but still I find this being a little bit odd. Thank you in advance.
https://help.libreoffice.org/Calc/Handling_of_Empty_Cells