https://bugs.documentfoundation.org/show_bug.cgi?id=92915
--- Comment #23 from Karl-W. Hoffmann <k_w_hoffm...@onlinehome.de> ---
(In reply to Alexander Nolting from comment #15)
> Hello Karl,
>
> I digged into your issue and found that LO doesn't support the
> {COUNT,SUM,AVERAGE}IFS starting from Excel 2007 onwards. Below you find an
> idea to substitute this by using SUMPRODUCT().
>
>
> SUMIFS( range ; column1 ; ">1" ; column2 ; "<5" ) <==> SUMPRODUCT( range *
> column1>1 * column2<5 )
> COUNTIFS( column1 ; ">1" ; column2 ; "<5" ) <==> SUMPRODUCT( column1>1 *
> column2<5 )
> AVERAGEIFS <==> SUMIFS/COUNTIFS
>
> My last two comment are for Miguel.
>
> Best regards
> Alex
Hello LO Calc Supporters:
I had the Oportunity to use Excel 2013 and saved the Spread-Sheet from Excel as
xxx.ODS File.
Opening this File (xxx.ODS) in LO (Desktop: WIN7 Prof-64Bit LO 5.0.0.5 and
Laptop: WIN7 Prof-64Bit LO4.4.4.3) does NOT vreate any Error-Message.
It seems to me, that the Spread-Shet is working perfektly under LO mow.
The "Suspected Cell "Auswertung D28" does now as Formula show this Contend:
"=SUMMEWENNS(Betrag;'file:///C:/Users/K-W.Hoffmann/Desktop/Kasse%20SV%202015.ods'#$$Konto;2110;VA;"M")"
Is it possible, that the conversation of XLSX Format to the LO Format during th
File-Opening?
Tao all of you a nice Week-End.
Karl
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
