One approach is to return all values to a worksheet in a multi-cell array formula.
SUMPRODUCT will handle arrays natively, so this formula does not require control + shift + enter.
The SUM function could be used as well, but would need to be entered withCSE.