Totals do not add up properly

Hello. I have written a spreadsheet with three sheets (see attached) You can see in sheet 3 ('totals') some formulas are displaying as text, and column AC has a 6 in which is not reflected in the total in AC12. If one total is not adding up properly it makes you wonder about all the others too!

I should mention I get a circular error message when I open the file, but when I ran the formula check tab thingy it said it was OK: I think that error just appears because Excel expects my formula to select cells next to the ones I selected but I don't want those cells. So I am ignoring that.

Thanks!