=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
[Solved] Formula Showing #NAME as result
-
- Posts: 2
- Joined: Mon Apr 15, 2019 7:09 am
[Solved] Formula Showing #NAME as result
Last edited by Hagar Delest on Mon Apr 15, 2019 7:53 am, edited 2 times in total.
Reason: tagged solved
Reason: tagged solved
Nageswar
OpenOffice 3.4.0
Windows 7 OS
OpenOffice 3.4.0
Windows 7 OS
Re: Formula Showing #NAME as result
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().
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 2
- Joined: Mon Apr 15, 2019 7:09 am
Re: Formula Showing #NAME as result
how can update which version of Calc support all formulas.... thank you
Last edited by Nageswar992 on Mon Apr 15, 2019 11:34 am, edited 2 times in total.
Nageswar
OpenOffice 3.4.0
Windows 7 OS
OpenOffice 3.4.0
Windows 7 OS
Re: Formula Showing #NAME as result
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/
Install the latest Still version of the LibreOffice. It is the LO 6.1.5 version today.
https://www.libreoffice.org/download/download/
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: [Solved] Formula Showing #NAME as result
(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.
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.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München