101,132 views
Advanced Excel: Master the sumproduct function. The basic use of the SUMPRODUCT function is to add up a multiplication of matrices. This is a matrix formula that does not need to be written followed by ctrl + shift + enter. The difference with SUMPRODUCT is that it can be used to solve a series of problems. It can behave like a sum.ifs, counts, vlookup, index+match, among others. SUMPRODUCT is better than sum.ifs and counts because it supports several different criteria, while these accept only one criterion. I hope you like it! See you next time! New Excel