If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

How do I do this excel function in Libre Office

danjo-xx · 2019-03-24 20:24:47

=sum(a1:a150) every time I try it another cell number appears at the end of above formula, whatever that is about.:confused:

24-03-2019 8:24pm

#1

danjo-xx

Registered Users, Registered Users 2 Posts: 5,395 ✭✭✭

Join Date: September 2008

Posts: 4340

=sum(a1:a150)

every time I try it another cell number appears at the end of above formula, whatever that is about.

0

Comments

#2 24-03-2019 8:42pm

28064212

Registered Users, Registered Users 2 Posts: 10,906 ✭✭✭✭

Join Date: May 2005

Posts: 10175

Just a guess, but are you using the arrow keys to "leave" the cell when you've finished entering the formula? You need to use either Enter or Tab. The arrow keys allow you to highlight a cell to include it in your formula

Boardsie Enhancement Suite - a browser extension to make using Boards on desktop a better experience (includes full-width display, keyboard shortcuts, dark mode, and more). Now available through your browser's extension store.
Firefox: https://addons.mozilla.org/addon/boardsie-enhancement-suite/
Chrome/Edge/Opera: https://chromewebstore.google.com/detail/boardsie-enhancement-suit/bbgnmnfagihoohjkofdnofcfmkpdmmce

0
#3 27-03-2019 8:42pm

danjo-xx

Registered Users, Registered Users 2 Posts: 5,395 ✭✭✭

Join Date: September 2008

Posts: 4340

28064212 wrote: »

Just a guess, but are you using the arrow keys to "leave" the cell when you've finished entering the formula? You need to use either Enter or Tab. The arrow keys allow you to highlight a cell to include it in your formula

Good point and I think I've got the hang. Should it not be the exact same as excel?

0