Have you ever thought of the humble SUM function as a secret weapon for advanced analytics? Most Excel users see it as a basic tool for adding numbers, but what if I told you it could do so much more?

You can use the PRODUCT() function to multiply monetary values in your Microsoft Excel spreadsheet. Functions allow you to perform a specific set of calculations in a cell, column or row. The PRODUCT( ...