Page 1 of 1

[Solved] Formula Showing #NAME as result

PostPosted: Mon Apr 15, 2019 7:12 am
by Nageswar992
=sumifs($D$3:$D$22;$A$3:$A$22;"="&A3;$B$3:$B$22;"="&B3)/countifs($A$3:$A$22;"="&A3;$B$3:$B$22;"="&B3)
the formula i used was this ...any suggestions are welcome.?


Thank you

Re: Formula Showing #NAME as result

PostPosted: Mon Apr 15, 2019 7:17 am
by FJCC
If the version listed in your signature is correct, I think you will have to update. If I remember correctly, version 3.4 did nto have sumifs() or countifs().

Re: Formula Showing #NAME as result

PostPosted: Mon Apr 15, 2019 7:20 am
by Nageswar992
how can update which version of Calc support all formulas.... thank you

Re: Formula Showing #NAME as result

PostPosted: Mon Apr 15, 2019 7:47 am
by Zizi64
The LibreOffice Calc has a higher compatibility with the functions of the Excel and Google Sheet.
Install the latest Still version of the LibreOffice. It is the LO 6.1.5 version today.
https://www.libreoffice.org/download/download/

Re: [Solved] Formula Showing #NAME as result

PostPosted: Mon Apr 15, 2019 5:09 pm
by Lupp
(Spoken aside)
I would prefer to dissuade from google sheets (as also from MS Office 365). It might be the next software (besides Excel) for which incompatibility is the "raison d'ĂȘtre" and will be reinforced as soon as weakened by competitors in their struggle for compatibility. The big players are trying to get everything into their clouds where nobody but themselves can see what happens.