Need dedicated support? Click here
Need dedicated support?
Click here

Sumifs formula bug and misrepresentation in FR version at least

formulas SOMME.SI.ENS work fine when created,but when the file is saved , closed and reopened, they do only if the range that is used is in the same spreadsheet, and it truncates parameters … A nightmare to use.

We tried on cloud as well as desktop versions, 7.1 to 7.3, French version

let’s say we have « .=SOMME.SI.ENS(‘Synthèse cyber par activité’!I$2:I$98;‘Synthèse cyber par activité’!B$2:B$98;A6) »

if closed and reopened it shows as

« =SUMIFS(‘Synthèse cyber par activité’!$I$2:$B$98,A6) »

so missing arguments and doesn’t work anymore

on 7.1 to 7.3 not working both desktop and cloud

and again… how to submit a file for analysis?

Hello @gregoryVDV

how to submit a file for analysis?

You can upload it to some external storage and provide us with download link.

test here

same bug on 7.1 and 7.3

This is most likely a bug. Thank you for the file.
We are checking the situation. I will let you know when I get something.

Hello, @gregoryVDV

We have created bug report number 61674 based on this case.
Thank you for reporting this issue. Our team is already working on it.

Hi @gregoryVDV
We fixed the issue #61674 that you reported.
Fix will be included in version 7.4.

hey @gregoryVDV
I am writing to inform you that we have already launched the new version 7.4 of the Document Server