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?

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?

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?

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?