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?