SUM problem
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 |
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) In article , "Jaan" wrote: 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? |
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 . |
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 . |
Thanks, this is working perfectly now
"JE McGimpsey" kirjutas: 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) In article , "Jaan" wrote: 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? |
All times are GMT +1. The time now is 07:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com