I tried a SUM function on a row of numbers on a table =SUM(B9:X9) and I got a 0
The numbers are formatted as numbers, and I operate calc in Version: 6.4.2.2 under Mac OS10.15.4
Do Functions work on Rows?
Yes, they do.
The numbers are formatted as numbers, …
Formatted is the operative term. Your numbers are still stored as digit strings, and not as binary encoded numbers. Cell formatting does not change cell content, only appearance/rendering (and to some extent, interpretation of input).
You need to enter numbers, after you now have ensured that cells are not formatted for text input. Search/replace can help you with a quick conversion:
- Select the offending number range
- Menu item
Edit-Find and replace - Search term
.*(a period and an asterisk) - Replace with:
$0 - Tick
Regular expressionsandOnly in selected cells - Click
Replace all
Thank you! I selected the row and did what you suggested. The numbers survived and the functions worked! How does one find out about such things? I m sure many users would like to know how to change the formatting (and change it back).
How does one find out about such things?
By trial and error, mostly. Then ask around when you are stuck.
The “proper” way to find out is by being taught. SkillShare is one place to start for help with self-teaching. Mostly focused on Excel, but the basic skills are much the same for all spreadsheet applications.
Do they teach this in school? Mostly not. I know. I work in ICT support in a school, and face the lack of basic spreadsheet skills every day.
So, you are not alone. Just ask around. Try stuff out, or take some course. One day you will be the one providing the answers.