SUM problem

[Guest]

How I can sum all same names values
A B C D E
F G
1 Jim Phil Jim Arthur Phil Tom Jim
2 15 8 42 87 14 11 25
3
4 Phil Jim Jim Arthur Phil Tom Jim
5 98 65 32 12 45 78 85
example A6=Jim15(A2)+Jim42(C2)+Jim65(B5)...
A7=Phil8(B2)+Phil14(E2)+Phil98(A5)...
Every day the names on the different places
How I can sum name values?

 

[JE McGimpsey]

One way:

A6: =SUMIF($1:$1,"Jim",$2:$2)+SUMIF($4:$4,"Jim",$5:$5)
A7: =SUMIF($1:$1,"Phil",$2:$2)+SUMIF($4:$4,"Phil",$5:$5)

 

[Jason Morin]

Total for Phil:

=SUM(SUMIF(2:2,"Phil",3:3),SUMIF(4:4,"Phil",5:5))

HTH
Jason
Atlanta, GA

 

[Guest]

Thank Jason,but this formula calculating only " " value on the 5 row
Sorry, if my mistake

"Jason Morin" kirjutas:

Total for Phil:

=SUM(SUMIF(2:2,"Phil",3:3),SUMIF(4:4,"Phil",5:5))

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks, this is working perfectly now

"JE McGimpsey" kirjutas: