and how can i fix this? So, if your numbers are formatted as numbers, but your Excel Sum formula still returns zero, trace and fix the circular references in your sheet (Formula tab > Error Checking > Circular Reference). See screenshot: 3. My preferred method is to reference the header cell to create the absolute reference for the first cell in the range. Thank you ! Software Hi! I want to total the best 10 results for each person from the total of the points and exclude the score.