I'm new to OO and to doing formula's.. and so I need some help please..
I'm trying to do a simple spreadsheet that adds up the total of optical frames by suppliers name that have been sold, at the bottom of the page next too the suppliers name.
Optimate 2
Moscon 2
I have very little, to no knowledge on how to do this? Please could you let me know how the sum should look in the cell.
PS. I can't get the red lines under the words to go away either
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 you could post an example file, we could see what is going wrong. To do that, click Post Reply then look for the Upload Atachment tab just below the box where you type a response.
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.
Allways attach "the "real thing" (OpenOffice document), not an image or pdf of it, except the question is explicitly about the view or the export.
(Just a hunch:)
There are two frequently occurring issues suspectable here:
-1- Your supplier names may possess trailing spaces.
-2- What you assume to be numbers is actually texts consisting of decimal digits, and thus looking like numbers.
As I suppose you didn't want to just count the number of rows containing a specific supplier, but to sum the respective numbers, I would suggest you study the attached example.
To be clear: If the cause of the problem actually is -1- or -2-, dont't leave it at that, but make sure that texts needing comparison NOT contain additional and or trailing whitespace, and that content being expected to be numbers actually IS numbers in the technical sense.
Please come back with respective questions if applicable.
Typical mistake(*): There is a trailing space in the "Optimate" entries, which is missing in the summation table. While "Optimate" and "Optimate " looks the same to you and me, the software sees them as different.
Use data validation to improve input.
Note that pasting into cells may defeat validation settings. For more secure integrity checking you may need to create an input form.
(*) IOW: You are not the first to do this, nor will you be the last. Those invisible (leading and trailing) spaces have their ways of sneaking into our data.
