SUMIF's with TEXT

[lynchbro]

I am trying to create a formula to look up off of a master sheet to return the sum of account balances by investor numbers for a particular group denoted in the master sheet.

I currently have 3 tabs, TICO, RCH & PCM. Each of these tabs have investor account numbers with their allocations.

Then the master sheet has all of the account numbers broken out by the 3 groups.

On the individual group tabs I would like to pull the ending balance data from the master sheet. Each group tab in Cell A1 has the name of the group with matches back to what is on the master sheet.

i thought i would have to do:

=IF(A1=MasterSheet!A:A,SUMIF(MasterSheet!B:B,TICO!B9,MasterSheet!C:C))

Where on the master sheet A:A represents the group name, B:B represents the investor account numbers & C:C represents the ending balances.

And the TICO B9 is the investor account number for that group.

Any help!?

 

[lynchbro]

ARG! I mis-typed the first time I tried!!!

This is great!!!!!

Thank you!

 

[Jonmo1]

Great, glad to help.