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
.
|