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

Sumifs formula bug and misrepresentation in FR version at least

Docs
, ,
#1

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?

#2

Hello @gregoryVDV

how to submit a file for analysis?

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

#3

test here

https://we.tl/t-qNPQQ5eZe6

same bug on 7.1 and 7.3

#4

@gregoryVDV
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.

#5

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.

#6

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

#7

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