Sohu.com Inc. (Sohu) is an online media, search and game service company, which is engaged in providing online products and services on personal computers (PCs) and mobile devices in the People's Republic of China (the PRC). The Company operates through three segments: the Sohu segment; the Sogou segment, and the Changyou segment.
Toggle absolute and relative references. It's much faster and easier than typing $ characters manually. To convert an existing formula, enter cell edit mode, place the cursor in or next to the reference you'd like to convert, then use the shortcut. Note: in Excel 2016 for the Mac, you can also use fn + F4.
Note that if your criteria is a text string or an expression, this must be supplied to the function in quotes. Also note that the Excel Countifs function is not case-sensitive. So, for example, the text strings TEXT and text will be evaluated as equal. Excel Countifs Function Examples The spreadsheet below shows a set of exam results for a class of students. The Countifs function can be used to find the number of rows in the data set that satisfy conditions relating to the subject, score and gender.