Google sheets array SUMPRODUCT Google Sheets function Written by Data Empower May 18, 2025 Determines the total of the products derived from corresponding elements in two arrays or ranges of the same size.