SUMIF Function

SUMIF() function sums up a numerical range given criteria from another range of equal dimension. The criteria can test whether the range equals to a certain text string, greater or smaller than a number, between certain dates etc. You can also use wildcards for fuzzy match. SUMIF() is one of the most used functions in … Continue reading SUMIF Function