The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)

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.

Word 2021 for Windows enables you to create compelling content and includes co-authoring, new stock media from the Office Premium Creative Content collection, and new Draw tab additions such as Point Eraser, Ruler, and Lasso.

Important: This article is intended for users trying to use sign up for self-service password reset.This means that you’ll be able to reset your own work or school password (such as alain@contoso.com), without requiring your administrator’s help.

The circular arrows over the OneDrive or OneDrive for work or school notification icons signify that sync is in progress. This includes when you are uploading files, or OneDrive is syncing new files from the cloud to your PC.

The recommended (and easiest) way to get SP1 is to turn on automatic updating in Windows Update in Control Panel and wait for Windows 7 to notify you that SP1 is ready to install.

Choose number of pages to print per sheet: Printing multiple pages on a single sheet of paper is a useful technique to save paper, reduce printing costs, and create compact versions of your documents. The number of pages that can be printed on a single sheet depends on the capabilities of your printer and the printing options you choose (Example: 1, 2, 4, 6, 9 or 16 pages per sheet).

When you back up your files, apps, and settings in the cloud using your Microsoft account, you get 5 GB of free cloud storage and other benefits that protect your files with the latest security and make everyday tasks easier.

There are some common two-step verification problems that seem to happen more frequently than any of us would like. We've put together this article to describe fixes for the most common problems.

If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.