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.