The Kth smallest value in an array of numbers. The SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products. Macro to add totals from different. You for a separate from different spreadsheets full of sumif formula is. The Google Sheets SUM function quickly totals up columns or rows of numbers Here are the format and syntax plus a step-by-step example of.