bfunk1987 wrote:Ill explain tho, the first column is the prices, the second column is the amount of items(which are several values) and the last column is the total for each row. So what I need to happen first is everything in the second column added together. Then multiply that by the first column which would go in the third column. Then everything in the last column added together in the final row. Is this possible?
Writer has very limited ability to perform numeric calculations. It cannot add the comma-separated values in your second column. However you could select each cell in the second column and use Table → Convert → Text to Table → Separate at → Other → , → OK. Now you have the numbers in separate cells of a sub-table and can use a formula to add them, then multiply by the value in the first column. See
Writer Guide: Working with Tables Using Spreadsheet Functions in a Table.
You may find this task easier to accomplish this in Calc, which is designed to perform numeric calculations. If you have further questions about Calc, open a topic in that forum.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6. The locale for any menus or Calc formulas in my posts is English (USA).