Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How do I sum the values from two adjacent cells in a row from one sheet into a cell in a second sheet of the same workbook

I am using using Linux Mint 17 Cinnamon with LibreOffice 4.2.7.2. I have tried to use the Data\Consolidate feature to make this happen without any success. I used this feature successfully with an earlier version of Linux Mint in years past but without success in the current version of Mint. Instead of summing the values from cells A3 and B3 of Sheet 1 (with values of 2 and 4 respectively) and displaying a value of 6 in cell A1 of Sheet2, the displayed result in Sheet2 is a value of 2 in Cell A1 and a value of 4 in Cell B1. Cell B1 should not display any values at all. The result is the same regardless of how I set up the options. Can you enlighten me please.

How do I sum the values from two adjacent cells in a row from one sheet into a cell in a second sheet of the same workbook

I am using using Linux Mint 17 Cinnamon with LibreOffice 4.2.7.2. I have tried to use the Data\Consolidate feature to make this happen without any success. I used this feature successfully with an earlier version of Linux Mint in years past but without success in the current version of Mint. Instead of summing the values from cells A3 and B3 of Sheet 1 (with values of 2 and 4 respectively) and displaying a value of 6 in cell A1 of Sheet2, the displayed result in Sheet2 is a value of 2 in Cell A1 and a value of 4 in Cell B1. Cell B1 should not display any values at all. The result is the same regardless of how I set up the options. Can you enlighten me please.