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 ...

Learn how to open, navigate, and troubleshoot File Explorer in Windows, with answers to common questions and support assistance.

Learn how to manage the payment information and billing for your Microsoft 365 subscription.

Learn how to update your Xbox console offline.

How to use the SUMPRODUCT function in Excel, one of Excel’s math and trig functions, using multiplication, addition, subtraction, and/or division to return the sum of the products of corresponding ranges or arrays.

Learn how to use voice access for accessibility. This page includes accessibility help articles for people who use Windows voice access to control their PC and author text using their voice.

Learn how to make items on the screen appear larger by using Magnifier in Windows.

Here are the most likely causes for an unrecognized charge: A Microsoft subscription has recurring billing enabled.

Learn how to use Wi-Fi 7 and Wi-Fi 6 and WPA3 in Windows for better wireless coverage and network security.

Hotmail is now Outlook.com. Learn how to sign in to access your Outlook.com, Hotmail, Live, or MSN email account.