The SUMPRODUCT function has been my favourite function for about 20 years. It is so flexible. Soon it will be redundant thanks to dynamic arrays. In the old days (pre Excel 2007), SUMPRODUCT was the easiest way to perform multi-condition SUMIF calculations. When SUMIFS was released in Excel 2007 SUMPRODUCT become less important. SUMPRODUCT still … Continue reading The End of SUMPRODUCT