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

-----Original Message-----
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?

--
jaan
.