I am running a chess tournament and to keep track of scores use a spreadsheet where the winner of each game is chosen on one sheet and the COUNTIF function calculates their score on another sheet. However, two of the people aren't working properly (Roberto & Ashleigh) and I need the formulas to be fixed. I have spent a long time checking all the coding there is right but the error remains.
Last edited by Rcsprinter; 11-25-2013 at 04:27 PM.
G'day and welcome to the forum,
The fix your spreadsheet. Take out the leading space in the names that are not calculating.
At the moment on the 'Matches' tab in cell L1, you have " Roberto" you need to make it "Roberto". If you did the same for Ashleigh's the formulas will now work.
Last edited by ratcat; 11-26-2013 at 04:58 AM. Reason: wow this is my 1000's post. :)
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
I already saw that and corrected it before I started the thread; it made no difference. None of the formulas use L1 anyway.
If you have already corrected that leading space before the name, why was it in the attachment. Have you uploaded the correct workbook ?
Below is the formula used for "Roberto" as you can see, cell L1 is used in a formula. Highlighted in red.
=(COUNTIF(Matches!$L:$L,Matches!$L$1)-1)*$F$1 +(COUNTIF(Matches!$L:$L,"Draw"))*$F$2 +(COUNTIF(Matches!$12:$12,Matches!$A$12)-1)*$F$1 +(COUNTIF(Matches!$12:$12,"Draw"))*$F$2
Please if you don't understand the formula, let the forum know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Rcsprinter 
Register To Reply
Bookmarks