Match Command

[Yunus]

Hi,

In Sheet 1 I have a list of Transactions per Customer.
In Column E is a list of Transaction per Accunt Holders.
In Column F Is the Account nos for Account Holders

In Sheet 2 Is a Summary Table of Customers.
In Column C is the Account No.
In Column F of Sheet 2, I would like to state where the account No in
Sheet 2 Column C3 Matches the Account Nos in Sheet 1 Column F5:F200 then
Sum the Transaction of Column E i.e Subtotal(9,E5:E2000),

Thanks in advance.

 

[Yunus]

Hi,

In Sheet 1 I have a list of Transactions per Customer.
In Column E is a list of Transaction per Accunt Holders.
In Column F Is the Account nos for Account Holders

In Sheet 2 Is a Summary Table of Customers.
In Column C is the Account No.
In Column F of Sheet 2, I would like to state where the account No in
Sheet 2 Column C3 Matches the Account Nos in Sheet 1 Column F5:F200 then
Sum the Transaction of Column E i.e Subtotal(9,E5:E2000),

Thanks in advance.

Thanks all but I have stumbled upon it:

Sumif(sheet1!F5:F200,C3,sheet2!E5:E200)