Sumifs giving strange results but when saved the results seemd to be normal partly

Hi All

I have a workings sheet and summary sheet .

Using sumifs formula on summary tariff column c and d but in entering formula and dragging gives same numbers on both columns but in saving the value changes in column C and D but still the total at end of columns does not tally with workings sheets total.

I have tried on excel 2007 , excel 2013 and excel 2016 having the same issues .

example using trim on column A and B in summary tariff gave the same issue column F and G and H gives the same results but saving the results became good!!!

I d' ont where the problem is coming.

Can anybody help to sort out