To get the sum of a column use the SQL SUM function;
SELECT SUM(columnName) as sumOfColumn FROM tableName
"SUM(columnName) as sumOfColumn" takes the sum of "columnName" and creates a new result row named "sumOfColumn"
You can use DataAssist search to create the date range search.