Varchar to int CAST

 To use int based functions, you must cast the varchar to an int/double first.

ie:  select sum(value::double precision) from table;