this video shows the use of following Excel formulas: <br />1) sumifs <br />2)sumproduct <br />3)sumX2my2