Essbase Calculate Sum-Product in Essbase Using MDX In Microsoft Excel you can calculate the sum of products (A x B) for multiple lists of numbers (arrays) using a formula such as =SUMPRODUCT(D3:F3, D4:F4). Some common examples of when you may need this include weighted averages or an accumulated