Been away from Excel for a while and just knocking together a simple sheet. I've got a couple of calculations which are then summed but the sum is occasional +1 out from simply adding the two absolute ...

Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome.