By Victor Alarsa If you are one of those who loves to model using lots of “IF”, “AND” and “OR” functions, then this article is for you. Let’s discuss the SUMPRODUCT, which literally means summing up the multiplication (product) of two or more different arrays. For example, if you want to calculate total rental value … Continue reading The benefits of SUMPRODUCT?
Do you know how to count the number of cells filtering several different criteria using Excel?
By Victor Alarsa In essence, the COUNTIFS function is used to count the number of cells that meet one or multiple criteria, given a specific range of the array. You may have noticed that COUNTIFS has an "S" in the end, which differs from its cousin COUNTIF, which is programmed to count the number of … Continue reading Do you know how to count the number of cells filtering several different criteria using Excel?