Learn the basic and advanced uses of the Excel SUMPRODUCT function – formula examples to compare arrays, conditionally sum or count cells with multiple criteria using AND or OR logic, get a weighted average, and more.