The easiest way would be to union the tables and sum the result
eg
Select Sum(a) from (
Select Sum(field) as a from tableA
union all
Select Sum(field) as a from tableb
union all
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[
^]