Multiple IF statement SUMS?

[Demetious]

I am trying to validate a range of cells and if they contain my data, I am trying to add the values assigned below them. Here is a sample of the code I am using now.

=IF(MATCH("JOHN SMITH",'Show and Sell'!A25:A29,0),'Show and Sell'!A36,0)

I have data in A25:A29, C25:C29, E25:C29 and so on up to Q25:Q29. In other words...

=IF(MATCH("JOHN SMITH",'Show and Sell'!A25:A29,0),'Show and Sell'!A36,0)
+
=IF(MATCH("JOHN SMITH",'Show and Sell'!C25:C29,0),'Show and Sell'!C36,0)
+
=IF(MATCH("JOHN SMITH",'Show and Sell'!E25:E29,0),'Show and Sell'!E36,0)

and so on. My formula ended up being way to long, there has to be an easier way. The point behind this formula is to check if a name is on the roster for a multiple salesman sale. If so, the total they earned together is already divided by the number of salesmen but that number needs to be added to their overall sales which is on a different sheet called "Main Page". Thanks to anyone who can help.

 

[Demetious]

Maybe I can simplify this question.

I have some columns with sellers names in them.
A25:A34, C25:C34, E25:E34, G25:G34 <---To name a few

Each column has a list of up to 10 names and a total split amount (A36, C36, E36, G36) depending on how many names are listed. I have that working.

I want to search each column for a name eg., "John Smith" and add the amount in each column that his name appears in.

So if John Smith's name is found within A25:A34 and E25:E34, I want to SUM (A36+E36).

I can get individual parts to work but when I put them together, my formula breaks. Thanks to anyone who can help me =)

 

[Demetious]

I came up with this, and it works....somewhat.
The problem now is that it only adds the sum for the first name in the column and ignores the rest. So if I have multiple names in the boxes, which I will, it does not add them in. My brain is starting to get mushy. Again, thanks to anyone who can assist me.

=SUMIF('Show and Sell'!$A$25:$A$34,B5,'Show and Sell'!$A$36)+SUMIF('Show and Sell'!$C$25:$C$34,B5,'Show and Sell'!$C$36)+SUMIF('Show and Sell'!$A$25:$E$34,B5,'Show and Sell'!$E$36)+SUMIF('Show and Sell'!$G$25:$G$34,B5,'Show and Sell'!$G$36)+SUMIF('Show and Sell'!$I$24:$I$25,B5,'Show and Sell'!$I$36)+SUMIF('Show and Sell'!$K$25:$K$34,B5,'Show and Sell'!$K$36)+SUMIF('Show and Sell'!$M$25:$M$34,B5,'Show and Sell'!$M$36)+SUMIF('Show and Sell'!$O$25:$O$34,B5,'Show and Sell'!$O$36)+SUMIF('Show and Sell'!$A$40:$A$49,B5,'Show and Sell'!$A$51)+SUMIF('Show and Sell'!$C$40:$C$49,B5,'Show and Sell'!$C$51)+SUMIF('Show and Sell'!$A$40:$E$49,B5,'Show and Sell'!$E$51)+SUMIF('Show and Sell'!$G$40:$G$49,B5,'Show and Sell'!$G$51)+SUMIF('Show and Sell'!$I$40:$I$49,B5,'Show and Sell'!$I$51)+SUMIF('Show and Sell'!$K$40:$K$49,B5,'Show and Sell'!$K$51)+SUMIF('Show and Sell'!$M$40:$M$49,B5,'Show and Sell'!$M$51)