It’s important to note that this function ignores blank and text values. The second argument, criteria, can be a number, expression, text string or cell reference that specifies which cells to ...