J
John
I have two columns in Excel 2007 as follows:
Win/Lose/Draw League or Cup
Lose Cup
Win League
Draw Cup
Win League
I want to be able to count in two seperate cells the Total played for Cup &
League matches as follows:
League Matches Cup Matches
Played 2 Played
Wins 2 Wins 0
losses 0 losses 1
Draws 0 Draws 1
Points 6
All help would be greatly appreciated.
John
Win/Lose/Draw League or Cup
Lose Cup
Win League
Draw Cup
Win League
I want to be able to count in two seperate cells the Total played for Cup &
League matches as follows:
League Matches Cup Matches
Played 2 Played
Wins 2 Wins 0
losses 0 losses 1
Draws 0 Draws 1
Points 6
All help would be greatly appreciated.
John