Formula to match objects from 2 different worksheets, total linked sum

[Tslack]

I have a monthly workbook tracking sales and expenses.

The banking tab, 1st attachment, shows the COA number in column E, associated cost in column D

On the ledger Tab, 2nd attachment, I need to show the total sum of cost associated with the COA number
I need the total to show in the 2nd attachment, yellow highlighted cell (column C)

Bank Acct.JPGLedger.JPG

I'm fairly new at more complicated formulas, not a pro at all

[AliGW]

WSelcome to the forum.

Try the SUMIF function.

[Glenn Kennedy]

And if lost...



You have attached an image. That's not very easy to work with. Also... I'm lazy. I have to re-type your information before I can begin to address your problem. That puts me off completely.

So.

Do yourself a favour and please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough). However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever).

Unfortunately the attachment icon doesn't work at the moment. So,... instead click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Make sure confidential info is removed first!!!!

[Tslack]

Thank you Glenn, attached is the sample workbook

[Glenn Kennedy]

In C2, copied down:

=SUMIF('Bank Accounts'!E:E,Ledger!A2,'Bank Accounts'!D:D)