Brackets are negative-sum doesn't work?

I recently downloaded an excel spreadsheet from betfair showing P&L for a days betting. The P&L column showed losses in brackets and profits without brackets, but my attempts to total the P&L column resulted in the answer 'zero'. Can anybody let me know how to total the column?
Attached is a zipped xls file.
Thanks,
Robert Weaver