[Solved] Formula Showing #NAME as result

Discuss the spreadsheet application

[Solved] Formula Showing #NAME as result

Postby Nageswar992 » Mon Apr 15, 2019 7:12 am

=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
Last edited by Hagar Delest on Mon Apr 15, 2019 7:53 am, edited 2 times in total.
Reason: tagged solved
Nageswar
OpenOffice 3.4.0
Windows 7 OS
Nageswar992
 
Posts: 2
Joined: Mon Apr 15, 2019 7:09 am

Re: Formula Showing #NAME as result

Postby FJCC » Mon Apr 15, 2019 7:17 am

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().
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7259
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Formula Showing #NAME as result

Postby Nageswar992 » Mon Apr 15, 2019 7:20 am

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
Nageswar992
 
Posts: 2
Joined: Mon Apr 15, 2019 7:09 am

Re: Formula Showing #NAME as result

Postby Zizi64 » Mon Apr 15, 2019 7:47 am

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/
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8224
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved] Formula Showing #NAME as result

Postby Lupp » Mon Apr 15, 2019 5:09 pm

(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.
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2528
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 32 guests