| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
testing while suming
I have two columns of data as follows
1 teama 2 teamb 3 teamc 4 teama 5 teamb 6 teamc The number of rows will not change. I'm trying to sum the value that is associated with each team name. Can anyone point me in the right direction? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
testing while suming
Try this:
=SUMIF(B1:B6,"teama",A1:A6) If you want to list your teams in a range somewhere, eg D1:D3, then you can put this variation in E1 and copy into E2 and E3: =SUMIF(B$1B$6,D1,A$1:A$6) Hope this helps. Pete On Aug 14, 4:30 pm, angryelvis wrote: I have two columns of data as follows 1 teama 2 teamb 3 teamc 4 teama 5 teamb 6 teamc The number of rows will not change. I'm trying to sum the value that is associated with each team name. Can anyone point me in the right direction? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
testing while suming
SUMIF should work in this case
=SUMIF(B1:B6,"teama",A1:A6) would return 5 Just change the "teamL" part of the formula for different teams. "angryelvis" wrote: I have two columns of data as follows 1 teama 2 teamb 3 teamc 4 teama 5 teamb 6 teamc The number of rows will not change. I'm trying to sum the value that is associated with each team name. Can anyone point me in the right direction? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
testing while suming
Thanks for the answer. I'll spend more time in Help in the future....
"JLatham" wrote: SUMIF should work in this case =SUMIF(B1:B6,"teama",A1:A6) would return 5 Just change the "teamL" part of the formula for different teams. "angryelvis" wrote: I have two columns of data as follows 1 teama 2 teamb 3 teamc 4 teama 5 teamb 6 teamc The number of rows will not change. I'm trying to sum the value that is associated with each team name. Can anyone point me in the right direction? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| suming in add-ins | Excel Worksheet Functions | |||
| Suming values from a xls file | Excel Worksheet Functions | |||
| suming all specific cell in subsheets | New Users to Excel | |||
| Suming up a Lookup | Excel Worksheet Functions | |||
| Suming 2 cells if 1 = #N/A | Excel Worksheet Functions | |||
Hybrid Mode
