Create a new document. On the File tab, select New. Select Blank document, or double-click a template image or type the kind of document into the Search for online templates box and press Enter. Tip: For practice using Word features, try a learning guide like Welcome to Word or Insert your first table of contents. Add and format text.

COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments: criteria_range1 Required. The first range in which to evaluate the associated criteria. criteria1 Required.

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.

See plans and pricing. Get help with your questions about Microsoft Teams from our how-to articles, tutorials, and support content.