SUMPRODUCT and conditional summation
In this tip, we see how powerful SUMPRODUCT as an array function can be when doing condition summations.
In the example below, we wish to sum up any numbers in column D that correspond to the person referenced in C11. Whenever the value of the data in C3:C8 matches C11, the corresponding number in D3:D8 is added to the total.
D11 is an array formula, which is applied with CTRL - Shift - Enter
