Libre Calc: how to create a special cell so that I could reference to it from other sheets?

by kamokoba   Last Updated September 11, 2019 10:01 AM

I am trying to create a monthly budget sheet. It consists of 2 sheets. The first sheet (Sheet1) consists of 2 columns - column EXPENSE_TYPE and column AMOUNT. Its purpose is to display a total amount spent for each type of expense in a particular month. An example:

Travel                  1007$
Food                      45$
Utilities                 54$

The second sheet (Sheet2) is listing all the transactions that I made during particular month, so it has columns of DATE, EXPENSE_TYPE and AMOUNT. Its main purpose is to display a detailed info of each transaction that has been made in a particular month. An example:

  DATE     EXPENSE_TYPE             AMOUNT
20190901        Food                  23$
20190902      Utilities               15$
20190903       Travel                315$
20190903        Food                  22$

My goal is to bind the EXPENSE_TYPE and AMOUNT columns in Sheet1 and Sheet2, so that when I fill in data in Sheet2, the AMOUNT column with appropriate EXPENSE_TYPE row in Sheet1 is automatically updated. In my given example above, you can see that in Sheet2 there are 2 rows of Food expenses. So the sum of these expenses (23$ + 22$ = 45$) should automatically be calculated and displayed in Sheet1 column AMOUNT and row Food.

How can I do it? And maybe you could tell how this thing that I want to implement is called officialy? Cell binding? Cell referencing? Something else?

Thank you

Related Questions

Two related cells

Updated July 25, 2018 15:01 PM

Change LibreOffice titlebar text

Updated January 03, 2019 12:01 PM

Spreadsheet formula to display most recent prices

Updated October 15, 2015 06:00 AM