Question

Locked

How do I repeat an =If then else function down a column

By the.gnome ·
I have a spreadsheet for keeping scores in a local sports league. In cell A1 I have the number of league points for the match and in B1 I have the Team name. Each row is a match result. So I get

Points Team
3 Aztecs
1 University
1 Aztecs

etc

I want to scan the column to find the team name, then add the points value to another cell so it will show the number of league points a team has.

So in the example the league table will be

Points Team
4 Aztecs
1 University

Can this be done ?

Thanks in anticipation

the.gnome

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

If...then...else Function...

http://www.csie.ntu.edu.tw/~sylee/courses/clips/bpg/node12.6.2.html

http://www.free-training-tutorial.com/if-statement.html
if-then-else function with a healthy example:
http://answers.yahoo.com/question/index?qid=20080124021451AAPFxSx

Collapse -

How do I repeat an =If then else function down a column

by the.gnome In reply to How do I repeat an =If th ...

Thanks Peconet, but I can use If, Then, Else functions in programming but don't know how to do it in excel for changing cell references, if that is the correct way to solve my problem.

Your second link is interesting, but I don't think at first read that it meets my needs.

the.gnome

Collapse -

sumif?

by LocoLobo In reply to How do I repeat an =If th ...

Would the sumif function work? You should be able to tell it to add the values from column A where B = X. If you are using Excel you can look it up in help. Otherwise, you can look it up online.

Alternatively, sort the rows by team and do subtotals?

Collapse -

Sumif ?

by the.gnome In reply to How do I repeat an =If th ...

I bow to your knowledge, it works just as you predicted and is far simpler than my idea.

many thanks

the.gnome

Back to Desktop Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums