| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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 . |
|
#4
|
|||
|
|||
|
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 . |
|
#5
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
| Baffling formula problem | Excel Discussion (Misc queries) | |||
| Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
| File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
| label problem | Excel Worksheet Functions | |||
Linear Mode
