$q = new Query();
$q->select = ['SUM(columnThatIWantToSumUp)'];
$q->from = ["(" . $query->createCommand()->getRawSql()  . ") as sumOfTheColumn"];
$total = $q->queryScalar();