=Sum(Val(Nz([Custom6a],0)))
This one doesnt quite work because if there are values in a text field it sums those
=Sum(IIf(IsNumeric([Custom6a]),[Custom6a],0))
This one seems to work. as long as the output is numeric i get the correct result
(Could just set conditional formatting on the total...