Add transactions based on a matching code

[chrisguk]

I have two sheets:

Main Balance Sheet

	A	B	C
1	Code	ITEM	Total Transactions Based on Code
2	RO	Something
3	BA	Another
4	DE	Extra
5	SE	More	66

Transaction Sheet

	A	B
1	Code	Amount
2	RO	10
3	RO	24
4	SE	44
5	DE	22
6	SE	12

The formula should go in The "Main Balance Sheet" Column C It should add all transactions that match the code in the main balance sheet with the code against the transactions in the Transaction sheet. For example; On the main balance sheet table The code "SE" is seen twice in the transaction sheet so it adds both corresponding values in column B on the transaction sheet which is then visible as a total in the Main balance sheet.

Problem is I dont know how to do this and I have tried many ways including SUMIF and VLOOKUP

Can someone help?

 

[Fluff]

You can use sumifs like

=SUMIFS(Sheet1!B:B, Sheet1!A:A,A2)

 

[chrisguk]

You can use sumifs like

=SUMIFS(Sheet1!B:B, Sheet1!A:A,A2)

Sorry for sounding stupid but it doesn't seem to make sense according to my example data, if you can help a little more?

 

[Fluff]

The formula is summing the values in sheet1 col B if the values in sheet1 col A match the values in A2 on the main balance sheet.
I used Sheet1 as I don't know the exact sheet name for the transaction sheet.

 

[chrisguk]

The formula is summing the values in sheet1 col B if the values in sheet1 col A match the values in A2 on the main balance sheet.
I used Sheet1 as I don't know the exact sheet name for the transaction sheet.

Main balance sheet is sheet 1 and the transactios sheet is sheet 2

 

[Fluff]

In that case just change the sheet name in the formula.

 

[chrisguk]

In that case just change the sheet name in the formula.

Im sorry you have been very helpful so far maybe I have missed something of I didnt explain myself correctly.

On the transactions sheets the items are not fixed. I will enter them accordingly when I have new entries. The value on the "Main balance sheet" column C6 = 66 this value is based on the total amount of entries that appear on the "transactions sheet" that match the code in A5 on the main balance sheet. So in the transactions sheet I see to occurrences of the code SE.

 

[Fluff]

That's exactly what the formula does, although from the data you posted SE will only = 56 not 66

 

[chrisguk]

That's exactly what the formula does, although from the data you posted SE will only = 56 not 66

I actually feel dumb now because I cant get it to work: This is what I have

=SUMIFS('Transaction sheet'.C2:C34;A12:A33;A2)

Transaction - Sheet1 is actually called Transaction sheet

Main balance sheet - sheet2 is actually call Main Balance sheet

 

[Fluff]

Just take the formula from post#2 & change Sheet1 to 'Transaction sheet' & change the commas to semi-colons.