To use int based functions, you must cast the varchar to an int/double first.
ie: select sum(value::double precision) from table;