This video is part of a training course called Advanced IF functions.. Syntax. COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments:

For info on how to properly care for the power cord and power supply, see Clean and care for your Surface.. Safety and regulatory information. To view the safety and regulatory information for Surface and Surface power supplies, including shipping information and AC power cord safety, see Product safety warnings and instructions.. Where to find a power supply

If you want to stop a file or folder from syncing or backing up, you can pause the upload or download. See Stop syncing temporarily below for details.. If uploads or downloads with the OneDrive website are taking too long, or you selected the wrong files, they can be cancelled.

Sign out of your account and then sign in to your new account. If everything is fixed, move your personal data and files to the new account. To move your personal files from your old account to your new account, try opening File Explorer, expanding This PC > OSDisk (C:), and looking in the Users folder, where you should see folders for both accounts.

Clean up Mailbox. From the Settings > Storage page you should see a breakdown of how much space each folder in your mailbox is taking. Below, you should see a list of the folders represented in the breakdown with the option to permanently delete all items (or those older than 3, 6, or 12 months) in these folders to free up space.

You can easily insert a check mark (also known as a "tick mark") in Word, Outlook, Excel, or PowerPoint. These marks are static symbols. If you're looking for an interactive check box that you can click to check or uncheck, see: Add a check box or option button (Excel) or Make a checklist in Word. In your file, place the cursor where you want to insert the symbol.

To edit a PDF, open it in Word. This works best with PDFs that are mostly text. PDFs of book chapters or something that looks like a manuscript from a copier won't be formatted well in Word.

Note: If you forgot your account info and had to reset your security info, you must wait 60 days before closing your account.

Manage your Virus & threat protection settings. Use Virus & threat protection settings when you want to customize your level of protection, send sample files to Microsoft, exclude trusted files and folders from repeated scanning, or temporarily turn off your protection.. Manage your real-time protection. Want to stop running real-time protection for a short while?

If you need instructions for adding an email account using advanced settings, go to Use advanced setup to add a POP or IMAP email account in Outlook for PC. Outlook won't accept my password. If Outlook won’t accept your password and you know you’re using the right password for your Gmail account, you might have an older version of Outlook that doesn't currently support this faster Gmail ...