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],…)

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Browse on the go with the new Microsoft Edge for Android and iOS devices. Microsoft Edge offers better protection and privacy, and can sync your favorites, passwords, and more across your desktop and mobile devices.

Introducing Microsoft Phone Link Our evolution of the former Your Phone app brings a new name to the user experience. With the new Phone Link on your Windows PC and the new Link to Windows app on your Android device, accessing your mobile apps and content has never been easier!

Lithium-ion batteries wear out over time, which can result in a battery not holding a charge for as long as it did when it was new. Keeping the battery charged to 100% all the time can cause it to deteriorate faster.

Ensure these modes create an alert that is visible on your device. Make sure you have a device signal and Internet connection. Make sure your phone calls and text messages are getting through to your mobile device.

Using clipboard. When you copy content on your PC, it’s automatically copied to your clipboard for you to paste. You can paste multiple items from your clipboard history, and you can also pin the items you tend to use all the time and sync your clipboard history to the cloud.

Resolve Windows blue screen errors with tips and resources to do your own troubleshooting, or contact the Microsoft support if you need more help.

Alternatively, you can install any website by going to the top corner of the browser and select Settings and more … > Apps > Install this site as an app.

Set up PC folder backup. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help & Settings icon then Settings.). Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings.)