COUNTIFS function. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met. This video is part of a training course called Advanced IF functions.

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.

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

Sending limits in Outlook.com. Important: From February 1, 2023, we are making changes to storage. Learn more. To help protect against abuse by spammers, Outlook.com limits the number of email messages that you can send in a single day, as well as the number of recipients for a single message.