Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping score
Dear Excel(lent) users,
I am making a very simple score sheet for a korfball competition. In a number of columns I have different sets of information. I am now focussing on the following: Column A Column B Column C Column D 3 2 Team 1 Team 2 2 1 Team 2 Team 3 1 1 Team 3 Team 1 2 2 Team 2 Team 1 3 1 Team 1 Team 3 Now I want to know the score of the teams (how many goals they scored). E.G. Team one scored 6 goals and received 3 So I am making a new set of columns with the following info Scored goals Goals Against Column E Column F Column G Team 1 6 3 Team 2 4 2 Team 3 1 2 Can someone help me please? ------------------------------------ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping score
With the teams listed in E1 down,
In F1: =SUMIF(C:C,E1,A:A) In G1: =SUMIF(D:D,E1,B:B) Select F1:G1, fill down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "The Fool on the Hill" wrote: Dear Excel(lent) users, I am making a very simple score sheet for a korfball competition. In a number of columns I have different sets of information. I am now focussing on the following: Column A Column B Column C Column D 3 2 Team 1 Team 2 2 1 Team 2 Team 3 1 1 Team 3 Team 1 2 2 Team 2 Team 1 3 1 Team 1 Team 3 Now I want to know the score of the teams (how many goals they scored). E.G. Team one scored 6 goals and received 3 So I am making a new set of columns with the following info Scored goals Goals Against Column E Column F Column G Team 1 6 3 Team 2 4 2 Team 3 1 2 Can someone help me please? ------------------------------------ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping score
Thanx !
It worked ! "Max" wrote: With the teams listed in E1 down, In F1: =SUMIF(C:C,E1,A:A) In G1: =SUMIF(D:D,E1,B:B) Select F1:G1, fill down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "The Fool on the Hill" wrote: Dear Excel(lent) users, I am making a very simple score sheet for a korfball competition. In a number of columns I have different sets of information. I am now focussing on the following: Column A Column B Column C Column D 3 2 Team 1 Team 2 2 1 Team 2 Team 3 1 1 Team 3 Team 1 2 2 Team 2 Team 1 3 1 Team 1 Team 3 Now I want to know the score of the teams (how many goals they scored). E.G. Team one scored 6 goals and received 3 So I am making a new set of columns with the following info Scored goals Goals Against Column E Column F Column G Team 1 6 3 Team 2 4 2 Team 3 1 2 Can someone help me please? ------------------------------------ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping score
You're welcome !
Thanks for calling back .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "The Fool on the Hill" wrote: Thanx ! It worked ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimum Exam Score Calculator | Excel Worksheet Functions | |||
Percentage score formula | Excel Worksheet Functions | |||
Golf Score Formula needs tweaking | Excel Discussion (Misc queries) | |||
2 Dimensional Lookup by column & rows to return score grade | Excel Discussion (Misc queries) | |||
Highest Score for each Test | Excel Worksheet Functions |