You can also use special characters to look for partial records. For example, if you type=COUNTIF(A1:B10, “*college*”), you’ll see the number of records that contain the word “college”. In this case, that’