Hi Neil,

What if you copy the data and Paste using Values Only to another sheet. If you were to take many races and Paste Values Only and then do a Pivot of these numbers (without the formulas) you may get what you desire. If that is wrong, then I'd need to see why your formula interferes with the Pivot. You can attach a sample workbook showing what is wrong and we can look at the problem.

To attach a sample workbook, click on "Go Advanced" and then on the Paper Clip Icon above the advanced message area.