in the C/limit calc - I want the total to be automatically round up

is there a possibility that the answer in column 4 will automatically round up rather than for me adding up a column and do the round up

I might have misunderstood your objectives. I thought you wanted the column labeled "C/limit calc" to look like the column labeled "round up to nrst 10,000".

If you want to keep the exact values in the column labeled "C/limit calc" (3,805,175.04 etc), and you just want the "Total Annual Expenditure" in D9(?) to be 5,040,000, the sum of the "C/limit calc" values each rounded up to 10,000, you can replace current formula that results in 5,000,000 with:

=SUMPRODUCT(ROUNDUP(D2:D8,-4))