Data Analytics in Microsoft Excel using Dynamic Array Formulas Examples: 1. Amount sold by trader for each year. =SUM(FILTER(SALE,(YEAR(DATE)=($B32))*(NAME=C$31))) 2. Get the Total Sales by Each Trader? =SUM(CHOOSECOLS($C$31:$E$34,MATCH(C$37,$C$31:$E$31,0))) 3. Who had the first, second and third highest sales? =TAKE(SORTBY($C$37:$E$37,$C$38:$E$38,-1),1,3) | Excel Basement