Excel evaluates everything between the two delimiters as the string to match. Now the COUNTIF() function can ... it should show that three commissions to date are higher than the previous year ...