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

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:

Options

24-03-2019 9:24pm

#1

danjo-xx

Registered Users Posts: 5,393 ✭✭✭

Join Date: September 2008

Posts: 4339

=sum(a1:a150)

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

0

Comments

Options
#2 24-03-2019 9:42pm
28064212

Registered Users Posts: 10,634 ✭✭✭✭

Join Date: May 2005

Posts: 9912

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
Options
#3 27-03-2019 9:42pm
danjo-xx

Registered Users Posts: 5,393 ✭✭✭

Join Date: September 2008

Posts: 4339

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