How to reference cell to the left (Excel)

Question

I'm trying to do some calculations based on team results in Excel. The format is:

Team | Player | Yards
 A   |   x    |  100
 B   |   y    |  142
 A   |   z    |   93

I'd like to be able to sum all the yards for a particular team, so for example if there are several players from team A then it sums their yardage. How would I go about doing this?

The dataset is long enough that it is impractical to do it all manually.

Thanks in advance!

score 1 · Answer 1 · edited Nov 06 '15 at 02:08

1

You can use the formula SUMIF

For example, if your team is in the A column, the players are in the B column and the Yards are in the C column, you can use the formula like this:

=SUMIF(A:A, "A", C:C)

which sums the yards of the team A.

edited Nov 06 '15 at 02:08

Insane

2,922

answered Nov 05 '15 at 16:19

RedSave

11

score 0 · Answer 2 · answered Nov 05 '15 at 16:15

0

Use a SUMIF formula. See below:

A SUMIF formula will add the values if a certain condition is true which is exactly what you are asking for.

answered Nov 05 '15 at 16:15

Eric F

3,328
5
29
44

score 0 · Answer 3 · answered Nov 05 '15 at 16:21

0

This is really easy with a Pivot Table (Insert > Pivot Table). Select Team as Row lables and choos the Sum of Yards as Values:

answered Nov 05 '15 at 16:21

agold

258

How to reference cell to the left (Excel)

3 Answers3