Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Share and access a view-only calendar in Outlook
Notes: If your email account uses Exchange, you will see Publish This Calendar, instead of the option to publish to a WebDAV server.This lets you publish your calendar directly to an Exchange Server. In the window that opens, select the publishing options you want, and click Start Publishing.. If you're using Microsoft 365, you can still publish your calendar to a WebDAV server, but you must ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, Outlook on the web, New Outlook for Windows
Device protection in Windows Security - Microsoft Support
Windows Security provides built-in security options to help protect your device from malicious software attacks. To access the features described below, tap the Windows Start button, type windows security, select it from the results, and then select Device security.
Get the latest Windows update - Microsoft Support
Windows devices may get new functionality at different times as Microsoft delivers non-security updates, fixes, improvements, and enhancements via several servicing technologies—including controlled feature rollout (CFR).. Windows will let you know if you need to restart your device to complete an update, and you can choose a time that works best for you to complete that update.
Manage app permissions for your camera in Windows
To use your camera with apps on Windows 11, you'll need to turn on some permissions in Camera settings. Then, you'll need to check your app permissions if you want to use your camera with apps.
Microsoft account security info & verification codes
Important: You don't need to remove old security information unless there is an account security risk (e.g. someone else has access to your old mailbox).
Applies To: Microsoft account dashboard
Using structured references with Excel tables - Microsoft Support
In our example data, we used the name DeptSales.. Use the following rules for table names: Use valid characters Always start a name with a letter, an underscore character (_), or a backslash (\).Use letters, numbers, periods, and underscore characters for the rest of the name.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013, Excel Mobile
Guidelines and examples of array formulas - Microsoft Support
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone
Turn on automatic forwarding in Outlook - Microsoft Support
In the Rule Address dialog, under Address Book, select the contact list that contains the address you want to forward to.. In the To box at the bottom, enter the email address that you want to forward all your mail to.Select OK.You should see the email address you want all of your email forwarded to inserted into the rule under Step 2.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Freeze panes to lock rows and columns - Microsoft Support
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016