Have your table as Defined Table. Then you can reference to datarange of any column like:
Tablename[ColumnName], or simply [ColumnName] in case of formula in same Defined Table.
The formulas will be like:
Code:
=SUMIFS(TableName[SummedColumnName], TableName[ConditionColumnName1], Condition1, TableName[ConditionColumnName1, Condition2, ...)
To sum with multiply criteria use SUMIFS(). And I advice to use always SUMIFS() and COUNTIFS() instead SUMIF() and COUNTIF(), as they work with any number of criteria.