|
What formulas do you use to add up the numbers? Just looking at the results you present, I would guess that for, say, New Zealand, to get their wins you sum across the row labeled New Zealand. Then to get the losses you sum down the column with NSF. It's got to be a problem with the loss formula - you must have some sort of weird addition going on where, when you sort the rows, it ends up trying to add values from above or below the table (which would lead to the #ref errors).
Can you post the formula in the sheet adding up the wins/losses for one team? Or give a link to it?
|