The easiest way would be to union the tables and sum the result
Select Sum(a) from (
Select Sum(field) as a from tableA
Select Sum(field) as a from tableb
Select sum(field) as a from tablec)as T
From each of the select statement you can add whatever filter you need.
See SQL Union