Help with IF, SUMIF or SUMIFS for full table

Hi all,

I am struggling to get my table to sum given a certain criteria.

E.G
.......A.......B.......C
1...Jack...Jack....Jim
2.....5.......6........4
3.....4.......7........9
4.....2.......3........7

I would like to know the total attributed to Jack (A2:A4 and B2:B4)

This is a small example of my table so jack may appear 16 times in Row 1 and have upto 150 numbers below his name each time.

I would then like to repeat the process for Jim and whoever else appears.

I have so far tried the following
=SUMIF(A1:C1,"JACK",A2:C4) however this only seems to calculate cells in the row immediately below (A2:C2) and ignores the rest of the data (A3:C4)
=IF(A1="Jack",Sum(A2:A4),) however this only calculates column A and I don't know how to keep it going to B, E, G and wherever else Jack appears...

Any help you can offer would be great. :-)

Try

=SUMPRODUCT(($A$1:$C$1="Jack")*$A$2:$C$4)