scored

Hi, i am trying to create a simple spreadsheet to track my team goalscorers, all i want is for the formula to notice a player name on one sheet and count the amount of goals he has scored on another sheet. The first sheet has the player name in column D and the amount of goals scored in that...

Good morning all, I have a problem I've been trying to solve for a while and I can't seem to find a good way to do it. I have survey data which needs to be visually represented in charts. Participants are asked a number of questions and can answer 1-6 (1 being the lowest, 6 the highest)...

I'm trying to setup a list that totals 'points scored' by team and 'points allowed' by team. I can use SUMIFS to total the points scored, as I can total referencing the team name, but I'm having a hard time figuring out how to total the points allowed, as that teams name will constantly change...

Hello, Have tried a number of ways and searched for an answer to this and it's probably an easy fix. I have a web link to a page and that is working great and I have seperated the columns I want ( d and e runs scored) I wish to do sums regarding to run values in D and E but wherever I place...

I have a column of minutes from goals scored 45' 5'67'89' 2'5'89' 15'67'79'78' is there a way of adding them all up please?

Hello guys Column A has the marks obtained by the students whilst column B has the name of the students. Two student have scored the same highest mark. Now I want to know how can i find the name of the two students who have scored the same highest marks. When I use...

I put together a NCAA Tournament Pool for a friend of mine last year and it seemed to work just fine, except, there were some ties that I should have realized would happen before I gave her the completed sheet. I will do my best to describe what I'm doing below. Column A-Ticket # (Means...

I am trying to automate a badminton league match scoresheet. I can use a SUM to calculate the total points scored, and SUMPRODUCT to work out total games won, but I then need to count up the number of 'best of threes' won. eg: First set may look like this: 21 - 19 10 - 21 21 - 19 Second set: 10...

Hi, I have a a column containing a list of scores (Column C) and another containing the list of checks completed (column B). I have a SMALL formula which ranks Column C from lowest to highest, but I am wanting to have a formula in Column B which lists the number of completed checks from...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...