Excel Hack 58: 5 ways to use the SUMPRODUCT function in MS Excel
The SUMPRODUCT function is one of the oldest in MS Excel, and most of the key functionalities it was well known for have been overtaken by newer functions such as COUNTIF and SUMIF. However, there are a couple of interesting ways the SUMPRODUCT function could come in handy to handle some common tasks in MS