« Data Validation 101 | Main | Random numbers: Normal Distribution II »
January 20, 2005
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
Posted by Dave at January 20, 2005 03:36 AM
Comments
Awesome, I will be a devote follower
Posted by: Luis at March 10, 2005 10:46 PM