Combine data

[devilfish]

I'm really not sure if what I'm trying to do is possible. Logically (at least to me), it should be. Let me begin by explaining.

I have 3 worksheets inside my file that I'm trying to work with and incorporate. The worksheets are titled "Referees", "T-Shirts" and "T-Shirt Totals". Each worksheet contains the following information: Team#, Name, and t-shirts sizes from YS - A4X. The range of columns is from A to M. Two worksheets only use 98 rows while my "Referees" worksheet uses 224. Now on to my problem.

What I'm trying to do is combine data from "T-Shirts" and "Referees" based on whether or not information in Column A - Team# for both sheets matches that of columnA - row2 of "T-Shirt Totals". I'm trying to get the "T-Shirt Totals" sheet to scan a range for each size and report back a total if the "Team#" is the same for both "T-Shirts" and "Referees". Each size t-shirt should have it's own total depending on whether the "Referees" and the "T-Shirts" match the "Team#" selected. I need to compile a total for all t-shirt sizes based on each team.

Here's what I'm using:

=IF(AND('T-Shirts'!A2:A98='T-Shirt Totals'!A2,Referees!A2:A224='T-Shirt Totals'!A2), 'T-Shirts'!J2:J98+Referees!J2:J224, "0")

Sometimes for some rows it reports the appropriate number, but most of the time, it doesn't report anything. I might be thinking to "databasey" for Excel, but this file was set-up by my mom for a non-profit youth soccer organization and I'm just trying to streamline it. She has to turn the file in tonight and unfortunately I just got to look at it last night. I'll apologize now for my bulky code. I'm not an advanced programmer. I've included the file because I know that I didn't explain myself properly.

Thanks for any and all help provided!!

Cheers,
DF